Daily count reports?

[dan]

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!

[Tara Bell]

were you able to do this without a plugin?

[Raimundas Juska]

You can get issues changed to some status by using this JQL - status changed to 'In Redo' after startOfDay(-14d). However, this will get you a list of issues, but not grouped by assignee.

To get issues grouped by Assignee/Agent you can use an app that I have created - https://marketplace.atlassian.com/apps/1219429/status-progress-report-gadget-for-jira