Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,367,588
Community Members
 
Community Events
168
Community Groups

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)

1 answer

1 accepted

0 votes
Answer accepted
Rik de Valk Community Leader Aug 24, 2022

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.

issue-statistics.png

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS

Atlassian Community Events