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

[Jade Louise Bridgeman]

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.'' 

[Sami Linnanvuo _Screenful_]

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.

[Danut M _StonikByte_]

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.  

Danut.

[Jade Louise Bridgeman]

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 :-(. 

 

[Danut M _StonikByte_]

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

[Nathan Phillips]

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]

Hi Nathan, Thank you for the confirmation. 

[Eduardo Anflor - MindPro]

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:

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.

I hope that helps.

Regards,

Eduardo

[Jade Louise Bridgeman]

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]

Hi, @Jade Louise Bridgeman 

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

Regards,

Eduardo

[Martins Vanags - eazyBI]

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]

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]

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