In Jira Service Desk we are struggling to come up with daily reports for some of our metrics. We would like to have on our Dashboard some sort of 14 day report with counts for the following:
- Number of OPEN Issues per day (at end of day ideally)
- Per Agent: Number of Issues changed to 'In QA' state
- Per Agent: Number of Issues changed to 'In Redo' state
- etc. etc.
I understand creating custom fields, and post-functions, and how they can be used to track some of this stuff. What I'm struggling with is how to create the charts, and in particular how to count these things daily on an ongoing basis.
For example, is there a way to use JQL somehow in the report setup such that it is relative to each day going into the past rather than relative to the current date?
Any and all suggestions would be most helpful!