How to create a Jira chart which will show me the historical count returned by particular JQL

Question

My query may seem complicated to understand clearly - so giving a simple example.

My JQL is :- project = "<Project_Name>" AND Sprint in openSprints() and status in (Open, Develop, Blocked)

Now I want to create a Jira gadget which will display the count of the above JQL for last 7 days.

Partha Majumder · Answer

Thanks for you reply. But this is not exactly helping me to prepare my report.

Let's say, the name of the above JQL in "Total In-Process Jira" and I need a chart like this (which I am currently doing manually) --

Date              Total In-Process Jira

1/2/19            139

1/3/19            135

1/4/19            141

1/5/19            130

venkatesh4317 · Answer

HI @Partha Majumder

Welcome to the community!

This might be closer to what you're expecting:

project = "abc" and created >= "-7d" AND NOT status changed

This would find all tickets that have been created in the last 7 days that have not yet made a transition.