JQL Filter

[lapacquah_bryant]

Hello,

I am Jira Admin, however new to Jira JQL etc.

I have two custom fields with single multiple choice

The user wants a report that details each custom field choices by percentage

Example: Incident Type, Other and Category Type, Lag

Is there away to create a filter that will have the percentage of these fields if reported together?  

Steps taken is trying to create a Report using filter however unable to get a percentage vs actual count.

"Request Type" in ("Example Request Type") AND "Incident Type" in (Autobahn, BlueJeans, "CF", Chrome, Citrix, CMM, Five9, Google, GP, Hardware, Hubble, , Jamf, Jira, MacOS,Other) AND "Category Type" in (Attach, Bookmarks, "Call Quality", Cert, Connection, Headset, Lag, Loading, Login, Monitor, Other, PA, Softphone, "Update", VDI)

[Rik de Valk · Accepted solution]

Hi @lapacquah_bryant ,
The short answer: no, JQL will not return any percentages; only flat lists of issues.

A long answer: there are Dashboard gadgets that will show percentages. For example the Issue Statistics gadget. For a single-select field these are perfect.

The Issue statistics doesn't allow you to set criteria based on two fields though.

What you could do though, is set up a dashboard with 1 Issue statistics gadget for each Incident Type. And you configure each of these Issue Statistics gadgets to show the breakdown per Category Type.

So your stakeholder can always go to this dashboard, find the Gadget for the Incident Type 'Other' and see how the Other incidents are broken down per Incident category.