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

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

[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

[Mārtiņš Vanags]

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? 

[Mārtiņš Vanags]

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