Dashboard - Summing Hours

[marx.drath]

I have a filter that includes a series of Tasks.  In the filter I have a field that lists the category for each Task and I have another field that lists the hours that will be used for that task.

In excel, I can quickly use a pivot table to get a pie chart showing the total number of hours aligned to each category and provide the percentage each category represents based on the number of hours aligned to that category against the total hours in the filter.

Is there a way to do this in a dashboard?

[Matt Parks]

I'm not sure of a way to do this in a dashboard but, if you have the Structure plugin, any number field can be added as a column. And the sum-up of any number field can also be added as a column so, if you grouped by the Category, you could get a total of the hours for each Category.

If you have Structure, I'd be glad to provide more detail as to how you could set this up.

[marx.drath]

Thank you for your response.

[Danut M _StonikByte_]

Hi @marx.drath,

Try the Pivot Table & Pivot Chart  gadget offered by our Great Gadgets app. It works like the one from Excel and can provide tables and charts (including pie) based on sum of hours or percentage from total.

The only mention is that it does not support multi-value fields like Category field of Jira. But if you category field is a custom field of type single-value, it will work just fine.

You could start with a free 1-month trial. If you have any questions, please contact support@stonikbyte.com.

Hope this helps.

Danut.

[Marlene Kegel - codefortynine]

Welcome to the community, @marx.drath.

I am Marlene, product manager of Quick Filters for Jira Dashboards. 

With the Jira native Pie Chart and Worklog Pie Chart gadget you can either sum up issues or  Time Spent, Original Estimate or Current Estimate. 

If you want to sum up other number fields, including custom number fields, you could try out our app Quick Filters for Jira Dashboards. It is possible to aggregate any Jira number field with the Quick Pie Chart gadget, the Quick Two Dimensional Filter Statistics Gadget, or the Quick Issue Statistics gadget.

[marx.drath]

Thank you!