Dashboard - Summing Hours

marx.drath February 26, 2024

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?

 

3 answers

1 vote
Matt Parks
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2024

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 February 27, 2024

Thank you for your response.

0 votes
Danut M _StonikByte_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 13, 2024

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.

image.png

image.png

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.

 

0 votes
Marlene Kegel - codefortynine
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
February 27, 2024

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 February 27, 2024

Thank you!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events