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

[Isaac Saunders]

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!

[Jack Brickey · Accepted solution]

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]

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]

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.

[Danut M _StonikByte_]

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.

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]

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!