Hi everyone. I have a JQL query and so I can easily get an appropriate count of JIRA issues, e.g. in the Search screen. Is there a way to get the count for the same query, but for a period like a month ago?
Regards,
Max
Hi maksya,
I would suggest using a board for that purpose (either a Kanban or a Scrum one), so that you can check its Cumulative Flow Diagram report, which shows the number of issues in each selected columns over time.
For said report to count with the tools you need, follow these steps:
You're all set-up! :)
After that, visit the board's Cumulative Flow Diagram report and:
And that's it! At this point you'd be able to track the number of unresolved problems over time.
Hope it helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @maksya and thanks for clarifying.
There are some status history search features that may help. Maybe something like:
project = PROJ
AND labels = problem
AND status CHANGED TO Closed
DURING ('yyyy/mm/dd', 'yyyy/mm/dd')
Please look here for more details:
https://www.atlassian.com/blog/jira-software/jql-the-most-flexible-way-to-search-jira-24
Best regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
well.. historical operations like CHANGED are focused on some specific and limited fields, not my case..
Let me extend the example.
Say, I have executed my JQL (project = PROJ and labels = problem and status not in (Resolved, Closed)) in the search and got 10 issues on the 1st of Dec 2020.
The next day I have moved 2 issues from PROJ to JORP project. Now, on 2nd of Dec my JQL returns 8 issues.
The next day I added the label "problem" to 7 new issues from the PROJ. Now the result is 15 issues. It is on 3rd of Dec.
And finally on 4th of Dec I have transitioned to Closed 3 issues. Now just 12 issues.
So my ultimate goal in the case is to get the row: 10-8-15-12
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @maksya
Thanks for the additional detail, and... I don't know how you would count changes to multiple criteria against a project's issues' logs with out of the box JIRA features for JQL.
Are you are using the Server edition? If so, you may need to work with your admin to run some queries directly against the database for JIRA, and custom write them to match your criteria.
Best regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @maksya
What is the query for which you want to get older items? Having this will help the community members answer your question. Thanks!
Best regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Bill Sheboy . Let it be even a simple JQL like:
project = PROJ and labels = problem and status not in (Resolved, Closed)
i.e. I can get the recent count of unresolved "problems" in the PROJ project, but I would like to get it for a moment a month ago, a week, etc. To build the trend of the counter.
Thanks,
Max
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.