Report focus on categories i one year

[Claire Corradi]

Good morning everyone,

I need to analyze all the jira tickets I've received in 2024. When we receive a ticket, we have the option to categorize it (e.g., travel, onboarding, props purchase, etc.).

Is there a way to generate a report that includes only the tickets from 2024 and shows them by category? For example, I'd like to see how many tickets related to travel have been resolved, how many were for onboarding, and so on in 2024.

I was able to find a report that shows the number of tickets by category, but it also counts tickets from previous years. I haven’t been able to find a way to apply a time filter for just 2024.

Many Many thanks :)

[Trudy Claspill · Accepted solution]

Hello @Claire Corradi 

Welcome to the Atlassian community.

Is "category" a selection list field in your issues? Does it allow only one value to be selected.

If so you could use the Pie Chart gadget on a Jira dashboard.

You would create and save a filter to select the issues you want to include. 

project=yourProject and created >= "2024/01/01" 

Then configure the specified gadget in a Jira Dashboard to use that filter.

That gadget may clump together categories that have the lowest number of issues. If you want to see each category's count explicitly you could use the Two Dimensional Filter Results gadget, probably. Select your category field as the Y access and Project as the X axis.

[Claire Corradi]

Hello @Trudy Claspill ,

Thanks for your suggestion, with some adjustment I made to have a chart with the issues of 2024 divided in the categories that I inserted in order to open the ticket.

Many thanks,

Claire 

[Trudy Claspill]

Hello Claire.

You're welcome.

If my answer or other answers helped you solve your requirement please consider clicking on the Accept Answer button above the relevant answers to mark you post as Solved.

[Rustem Shiriiazdanov _Actonic_]

Hello @Claire Corradi

Assuming you use JSM or some custom "Category" fields to sort your requests, I think you may achieve this easily combining Jira Filters and Issues statistics gadget.

Step 1: create and save Jira filter as shown below

Step 2: Use issue statistics gadget to show the pivoted data:

Hope this helps!

Regards,

Rustem

[Claire Corradi]

Dear @Rustem Shiriiazdanov _Actonic_ ,

thank you for your time. For sure I learned something new! I made to find the solution, throw another suggestion.

Thanks a lot again!

best,

Claire

[Rustem Shiriiazdanov _Actonic_]

Dear @Claire Corradi

you are always welcome! 

Regards,

Rustem

[Brett Beeman]

Hey, @Claire Corradi 

For starters, you can use this JQL to pull all tickets created in the year 2024:

created >= startOfYear()

 And you said that you could categorize tickets. I take it that you have different issuetypes setup for these. In which case, you can filter by issuetype like this:

created >= startOfYear() AND issuetype = Travel BY created ASC