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.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Jack Brickey

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

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:

Mykenna Cepek

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: