Field Comletion Percentage Comparison.

[Roger Bradley]

I’m trying to add a dashboard widget that can compare how often a specific field is completed across two different timeframes. Each timeframe is driven by its own JQL filter, which identifies whether the field was filled in or left blank. What I need is a widget that can show both the total number of tickets in that timeframe and the number of times the field was left empty, and then calculate the percentage of empty occurrences. For example, showing that a field was left blank 28% of the time if it was empty in 28 out of 100 tickets. I don’t need a single widget to compare both timeframes together; if I can find a widget that calculates the percentage for one timeframe, I can simply create two identical widgets (one for each timeframe) and compare the results visually on the dashboard.

[Danut M _StonikByte_]

Hi @Roger Bradley,

Welcome to the Atlassian Community!

Jira does not provide a built-in gadget that can calculate percentages based on multiple JQL filters.

To address this requirement, you may want to explore available apps on the Atlassian Marketplace, where you can find app designed to extend Jira’s reporting capabilities.

If I understood correctly, you already have the JQLs for a timeframe that return the issues filled-in and blank fields, and you need a way to calculate and display the percentage.

If you are willing to try an app, for this case I would recommend using the Advanced Issue Filter Formula gadget offered by our Great Gadgets app. The gadget is capable to display the count from filters, but also to combine these in custom math formulas (such as percentage calculation).

To obtain this, the gadget shall be configured like this:

 

If you have any questions on how to set this up using our app, feel free to contact support@stonikbyte.com at any time.

There might be other ways for displaying this info by using our app, like for example, using the CFD chart configured to display percentages, but this depends also on the type of the field. See more examples here: https://community.atlassian.com/forums/App-Central-articles/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

Danut.

[Arkadiusz Wroblewski]

Hello @Roger Bradley 

in Jira Cloud, there’s no native dashboard gadget that will do that percentage calculation for you. You can get the two counts easily, but Jira won’t do the “Empty / Total = %” math in a gadget.

What works without apps:

Create 2 saved filters per timeframe:

Total (timeframe A) = your JQL

Empty (timeframe A) = same JQL + AND "Your field" is EMPTY

Add two Filter Results gadgets (or just show counts via gadgets).
You’ll see “Empty = 28” and “Total = 100”, but you’ll do the % mentally.

If you want the % shown on the dashboard (best practice in Cloud):

Use Atlassian Analytics if you have it (Data Lake), you can calculate ratios cleanly.

Or use a Marketplace reporting tool like eazyBI to create a measure for Empty / Total and display it as a percent, then duplicate it for the second timeframe.

To help you more, we need more precise Details.

[Alexey Pavlenko _App Developer_]

Hi @Roger Bradley ,

Maybe I am missing something, but, after reading your post, to me 

the total number of tickets in that timeframe = the number of times the field was left empty.

If it's not the case, please distinguish the latter from the first one more clearly.

Best regards,
Alexey