Is it possible to get snapshot of jira issues statuses on the specific date? For example, I want to get statuses of issues for my project on 27th of January. It seems that it is not possible to do this with JQL. Are there any other approaches?
To make use of plain JIRA:
Make a couple of filters for your status, and add one "Issue Statistics' gadget per filter in a dashboard (say using Project Name as the criteria). So you will get count of one status per gadget.
status WAS "Open" DURING ("2013/01/27","2013/01/27")
There can be a small issue as those issues which got transitioned during that day will appear in multiple statuses (so pickup a holiday to avoid that situation, which is true in this case)
The above query will list the ticket that has the specific status on a specific date. However, if the status of the ticket got changed several times on the date then that ticket will meet the criteria for several status.
If I only want to find the tickets that has DONE status as the "last status" for the specific date, how should I write the query?
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event