Is there a way to count/total a number field of multiple issues in a filter or roadmap?

[Wendy Benson]

For example, I have a field called '# of Apps' in the issue type of Initiative (some have 1, another might have 6 or other). Can I get a sub-total, total, sum, or count of the number in this field for all Initiatives to display in a filter or roadmap? So if I have 6 Initiatives with a total of 15 from the # of Apps field, how can I show this?

[Nic Brough -Adaptavist- · Accepted solution]

Absolutely not!  The time logging in Jira is quite powerful and feeds a lot of reports.

It is closely related to estimating, but you don't have to do estimates if you don't need or want them.  l regularly work in projects that have no estimates but I do log time worked.

Get started at https://confluence.atlassian.com/adminjiracloud/configuring-time-tracking-818578858.html

[Kartheek Veeravalli]

Awesome.. actually now a twist - looks like we are after all we are using Hours object in JIRA. So now we are trying to get the data out to our internal BI application to do reporting.

So we are using JIRA APIs to pull all the data and we see that the object JIRA_Timespent_History has logged hours but we don't see how logged that hours.. where can I get that?

[Nic Brough -Adaptavist-]

Your API calls can also fetch the "work logged" data, which will include the users who logged it.

[Joshwa Marcalle]

And after you have that squared out, you will need a cool tool to see the hour logs in a way that makes sense and adds value. 

I recommend this one: https://marketplace.atlassian.com/apps/1219348/hours-reports-for-jira?hosting=cloud&tab=overview

There is my sales pitch ;) 

Hope it helps

Josh
OB1

[Kartheek Veeravalli]

Thank you but trying to get that data internally using API into our DB to use our BI platform that can combine multiple datasets into one place. Have a question about that though.

We are using JIRA APIs to pull all the data and we see that the object JIRA_Timespent_History has logged hours but we don't see how logged that hours.. where can I get that?

[Joshwa Marcalle]

Which BI Platform are you using?

If its something like Tableau, then there are already add-ons to help you connect your cloud instance quite easily. We use AIO Tableau. 

If the BI tool you are using is popular, then chances are there is a plugin already to help you get the data.

If there are no existing plugins, then your only choice is to develop your own Jira API application for this (not difficult).

You can get the time that workers have logged in Jira using the  Jira API:

https://developer.atlassian.com/cloud/jira/platform/rest/v3/?utm_source=%2Fcloud%2Fjira%2Fplatform%2Frest%2F&utm_medium=302#api-api-3-workflow-get