Reporting by Component

[JH]

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!

[Kian Stack Mumo Systems]

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.

[JH]

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

If you add the bottom numbers shaded in grey you will get the number for Total Unique Issues  which is 200 (the actual count of the ticket) but when you sum up the numbers on last column you will get 210 (which base from observation it counts the tickets based from the number of components assigned ie one ticket will be counted twice if it 2 components assigned) 

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. 

[Victor Mutambuki]

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

[JH]

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.