Percentage calculation based on value in a custom field

[Trevor Brace]

I created a custom field in my Jira cloud instance. It is type 'Checkboxes'. It will either be left unchecked, or checked 'Yes'.

I now want to create a filter (or other gadget for a dashboard) that will show me the following calculation, as a percentage:

• number of stories in the current sprint with yes checked / total number of stories in this sprint

Is this possible? I'm assuming I'll need to use ScriptRunner or some other plugin, but not really sure where to start.

[Jack Brickey · Accepted solution]

Hi Trevor,

Can you try creating a dashboard and adding a single pie chart gadget, and associate your project as the filter. Then select your custom field as the statistic if available. Disclaimer – I have never tried to use a checkbox custom field as a statistic in dashboard gadgets. Please let me know the results. I may give this a try as well.

[Mykenna Cepek · Accepted solution]

Also, the "Issue Statistics" dashboard gadget in Jira will give you both counts and a percentage. It's a bar chart, rather than a pie chart, but it might fit your original requirements better. And it takes up less space:

[Jack Brickey]

Good call. I like that gadget.

[Trevor Brace]

Very cool, and nice to have the counts and percentage without interacting.

[Mykenna Cepek · Accepted solution]

The simplest thing I can think, available in standard Jira (all versions, AFAIK) is to create a new Jira Dashboard, add a Pie Chart gadget, configure it on the project, and select your custom "Checkboxes" field as the "Statistic Type". Here's what it looks like for another "binary" field:

[Jack Brickey]

Great minds...😉

[Trevor Brace]

Ah, elegant! This will actually work. You have to hover to display the percentage, but I can live with that. Thanks!

[Jack Brickey]

Precisely! Glad it worked out.

[Trevor Brace]

I ended up creating a custom filter to use in the pie chart so I can limit the results to the currently open sprint. Works great...thanks again!