Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

I need to display a few metrics as a ratio or percentage, Help!?

Isaac Saunders February 7, 2024

Hello, I'm fairly new to Jira and would love some help with this issue. I am trying to display some metrics in a dashboard and need to show them as a percentage. Things like: Completed Tasks / Total Tasks, Completed Support Tasks / Total Support Tasks, Total bugs and defects/ total completed tasks and stories etc...

Any help would be greatly appreciated. 
Thanks!

2 answers

1 accepted

2 votes
Answer accepted
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 7, 2024

Hi @Isaac Saunders ,

have you played with creating a filter and applying to a gadget like the pie gadget? With this gadget, you can mouse over the various slices and see the percentage. You might want to create one by chart that is by issue type and illustrate your pie chart by status. 

For example, create the following filters and save them.

type = task

type = bug

type = "support task"

then on your dashboard create three pie charts, and associate each one to one of the above filters that Saved. Choose status as the metric to report against. Save that and give it a try.

Isaac Saunders February 8, 2024

Thanks @Jack Brickey , I appreciate the help. My issue now is that I'm unable to create a custom statistic to report the filter against. For example, I want to look at total support tasks over total tasks, giving us information about our support overhead. Is there a way to create something like this?

Another question I had is: Is it possible to look at the average time from when a ticket was created or moved to in-progress and when it was moved to done?

Thanks again for your help!

Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 8, 2024

So are "support tasks" a unique issue type? If so you could create a pie based on issue type using your Project as the filter for the gadget. This would show a slice per issue type, one of which would be the support task. So for example let's say you had issue types: support task, task, bug, feature with a breakdown:

  • support task - 33
  • task - 100
  • bug - 21
  • feature - 11

your total # issues the = 165. The pie chart would illustrate this info along with % when mousing over a slice.

for your last question you would need an addon app.

Like Isaac Saunders likes this
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.
February 8, 2024

Hi @Isaac Saunders,

Jira is quite limited when it is about calculating metrics like this. As already suggested, you could try the Pie Chart gadget. Or, the Filter Statistics gadget.

If you consider the option of an using a payed add-on, then your best option would be our Great Gadgets app. With the Advanced Issue Filter Formula gadget that our app offers, you can easily calculate and display the metrics / ratio in question. It allows you to apply from simple (like SUM, COUNT, AVERAGE) to complex math formulas over the issues from up-to 6 filters.

image.png

See also this article: https://community.atlassian.com/t5/App-Central/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

Hope this helps.

Danut

Isaac Saunders February 8, 2024

Hey Danut,

Thanks for the response. Unfortunately I can't add any paid add-ons right now. I will keep it in mind for the future though. 

Thanks!

Suggest an answer

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

Atlassian Community Events