Hi
I'm new to JIRA servicedesk and was tasked to create aging ticket report. I used Two Dimensional Filter Statistics (for the total number of tickets per component) and Filter Counts gadgets (for the total number of components by specific date range i.e tickets 61 days older, tickets 31 to 60 days older etc...), but when I sum up my total number in the filter counts, it doesn't match with the numbers i have in two dimensional filter.
I'm not a coder and i'm just starting to learn JQL, Is there a way i can display the number of tickets with multiple components assigned without affecting the total number of tickets we have? like in the screenshot below, i'd like to add another component "E" to display tickets with more than 1 component assigned?
Thanks!
Hey JH,
Have you thought about using the pie chart with the stat type set to Components?
This will show you the exact count of how many tickets are in each component, but also show you the correct number of results within the gadget itself. In the screenshot below, were I to add up each number I'd get a total result of 9,609, but I can easily tell that I have 7870 returned by the filter.
Hello Kian,
Thanks for your response!. I tried this before but this report doesn't reflect the actual number of tickets. To explain further, Here's the screenshot of my Two Dimensional Filter Statistics
I'm trying to find a way how to display in the report the total number of tickets, number of tickets assigned per component, number of tickets without components assigned and number of tickets that have multiple components assigned.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
JH,
Are the tickets resolved or unresolved? If the tickets are unresolved, try using the Average Age report.
In your Jira dashboard, use the average age report gadget get the results.
Victor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Victor,
Thanks for your response! The tickets are all unresolved. I tried the report you mentioned but it's not what we need. We need a report that will also display the number of open tickets with multiple components assigned.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Recommended Learning For You
Level up your skills with Atlassian learning
Learning Path
Get the most out of Jira Service Management
Solve customer problems efficiently and deliver outstanding service experiences.
Learning Path
Adopt ITSM practices to deliver exceptional service
Become familiar with the principles and practices that drive ITSM. Then, learn how to configure and use Jira Service Management to implement them.
Atlassian Certified Associate
Jira Service Management Agent Essentials certification
Prove you know what's essential to providing efficient and resolution-focused service in Jira Service Management.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.