How to report on cumulative values of a custom Number Field?

[Alex Cook]

We are using Jira Service Management as a tool to review potential pieces of chargeable project work, triage them and then track internal and external sign off.

Each ticket has a few custom Number Fields to record the financial value of that work (internal cost and external cost).

I want to do some reporting on this data so we can see the total value of work that we've quoted, how much was won and lost and how much has been delivered.

It's a simple JQL query to identify the tickets in each pot, but how do I report on cumulative totals of these Number Fields? Am I right in thinking that this can't be done in native dashboards so I'll need a marketplace add on, or export the date into a Power BI dashboard?

[Ajay _view26_ · Accepted solution]

Hi @Alex Cook 

You're right that native Jira dashboards don't give you a straightforward way to sum up custom number fields across a filtered set of issues. The built-in gadgets (pie chart, two-dimensional filter stats, etc.) can show counts and individual field values, but they won't roll up a "total internal cost" across 50 tickets for you. For that you can either use the Forge Platform for developing a custom App or use tailored solutions from the Atlassian Marketplace

[Alex Cook]

Thanks

I'm just having a play with "Easy Reports Free" which is allowing me to total up those fields. That'll do for my immediate need, but if there's a need for more in depth reporting I might just get data fed into Power BI (at which point it becomes someone else's job to deliver).