How to create a report which shows how many open tasks you've had per month?

Jade Louise Bridgeman February 25, 2025

Hello there support,

 

Basically, I need to create a report that shows how many issues there were at each past month with what their status was at that point in time - for example: 

Jan 2024 had X amount of ''Pending'', Y Amount of ''In Progress'', and Z amount of ''Client QA''.

Feb 2024 had X amount of ''Pending'', Y Amount of ''In Progress'', and Z amount of ''Client QA''.

Mar 2024 had X amount of ''Pending'', Y Amount of ''In Progress'', and Z amount of ''Client QA''.

ect ect ect (Preferably in a bar graph).

Is this possible using just JQL? I have tried multiple times to write this as its not a default report however I've had no Joy. - I have also read other forums trying to attempt similar reports to mine but to be told that this is not possible without a plugin/module?... any help would be appreciated!

 

Many thanks! 

**Note: ChatGPT says the following ''To track the issue changelog in Jira using JQL, we can't directly retrieve the full changelog data (like each individual change) with pure JQL because it doesn't have built-in support for fetching historical changes.'' 

5 answers

0 votes
Sami Linnanvuo _Screenful_
Atlassian Partner
February 27, 2025

Hi @Jade Louise Bridgeman with the Screenful add-on, you can track how many issues there were each month with what their status was at that time using either of these charts:

- Cumulative flow diagram
- Stacked bar chart

You can see all the available charts on the Tour page

Here's the guide for getting started with the free trial.

Here's the guide for importing data from JSM projects.

0 votes
Danut M _StonikByte_
Atlassian Partner
February 26, 2025

Hi @Jade Louise Bridgeman

Welcome to the Atlassian Community!

You could try the Cumulative Flow Diagram report of Jir; it should be available in the Reports section of your project. It is not so configurable and does not seem to be able to group data by time inervals, but it might be just enough for your needs. See https://support.atlassian.com/jira-software-cloud/docs/view-and-understand-the-cumulative-flow-diagram/.

If you need something better, you could search for a plugin on Atlassian Marketplace that offers such report or gadget. 

In case you want to try a plugin, our Great Gadgets app offers a Cumulative Flow Diagram gadget that can display this info for you with just a few clicks. It is highly configurable.  

image.png

Danut.

Jade Louise Bridgeman February 26, 2025

Hay Danut, 

Thanks for your response! 

Please see my screenshot where I am at reports, there does not seem to be a Cumulative Flow Diagram report :-(. 

 Screenshot 2025-02-26 at 16.49.40.png

Danut M _StonikByte_
Atlassian Partner
February 26, 2025

Yes, unfortunately this report does not seem to be available for JSM projects - it is available in software projects...

As advised already,  you could try an app from Marketplace. Our  Cumulative Flow Diagram gadget might be a good solution. Find more about it in this article: https://community.atlassian.com/t5/App-Central-articles/An-effective-dashboard-for-Service-Desk-and-Customer-Support/ba-p/2360369

Danut

 

0 votes
Nathan Phillips
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 25, 2025

Hello @Jade Louise Bridgeman,

You are on the right track! A marketplace app would be required in order to granulary report on the information you are looking to gain.

Jade Louise Bridgeman February 26, 2025

Hi Nathan, Thank you for the confirmation. 

0 votes
Eduardo Anflor - MindPro
Atlassian Partner
February 25, 2025

Hi, @Jade Louise Bridgeman 

Welcome to the community!

I believe you cannot retrieve this information using jira's out-of-the-box gadgets. Based on your text, you could try a simple-to-use marketplace solution. I work at Mindpro and I would like to suggest Mindpro Insights. You could create jira dashboards with different gadgets using JQL, showing status per month. Just an idea:

Screenshot 2025-02-25 at 12.32.44.png

 

You could add many different gadgets and configure one per month, for example. This is showing in bar format as you mentioned, but there are other custom gadget types you can select using this app.

 

Screenshot 2025-02-25 at 12.33.21.png

 

I hope that helps.

 

Regards,

Eduardo

Jade Louise Bridgeman February 25, 2025

Hay Eduardo, 

Yes that's the type of thing I am looking for... however the link you have provided does not work.

Eduardo Anflor - MindPro
Atlassian Partner
February 25, 2025

Hi, @Jade Louise Bridgeman 

Could you please try again? I have updated the link.

 

Regards,

Eduardo

0 votes
Martins Vanags - eazyBI
Atlassian Partner
February 25, 2025

Hi @Jade Louise Bridgeman 

If you are considering Jira apps and plugins, you could explore eazyBI

One of the sample charts is a cumulative flow diagram which woudl count issues by their historical status at the end (last day) of each period from Time dimension.

See an example here: https://eazybi.com/accounts/1000/cubes/Issues/reports/187032-cumulative-flow-diagram

Martins / eazyBI support

Jade Louise Bridgeman February 25, 2025

Hi Martins, 

 

Thank you for the suggestion. Does easyBI back track data?

What I mean by this is will it be able to present issue status data from eg; January last year till now in that graph? 

Martins Vanags - eazyBI
Atlassian Partner
February 25, 2025

Yes, from the moment issue is created till now. Each issue has a status in Jira, and status changes can be found in the issue changelog.

That is where eazyBI can find it and show issue in report by historical status on different time periods

Martins / eazyBI

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events