nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Trudy P Claspill

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.

All comments

Trudy P Claspill

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.

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

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

Screenshot 2024-08-16 092651.png

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

Screenshot 2024-08-16 092505.png

Hope this helps!

Regards,

Rustem

Claire Corradi

Hello @Trudy P 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

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

Trudy P 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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

unknown-hosting-type

jira-unknown-hosting-type