nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

All comments

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.

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!

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud