i want to get all the issues that are in the date with the most issues in that status.
example, if i have 5 issues:
issue 1 date 1/1/2015 status open
issue 2 date 1/2/2015 status open
issue 3 date 1/2/2015 status open
issue 4 date 1/2/2015 status open
issue 5 date 1/3/2015 status open
1/1/2015 only have 1 issue
1/2/2015 only have 3 issues
1/3/2015 only have 1 issues
in this case issue 2,3 and 4 all those are in date 1/2/2015.
my boss would like to get the date where we have the most issues in certain status. as the example, the date would be 1/2/2015
and also be able to count how many, in this case 3 issues. (this might have to be another query)
that way he can make a report with the max value of issues that we got was this date.
might need to be into a scripted field?
thanks
My first thought would be to get all the issues for the date range you are concerned with and export to Excel and do a quick Pivot table grouping by status and day. And if you need a dashboard reporting solution I would check out EazyBI here: https://marketplace.atlassian.com/plugins/com.eazybi.jira.plugins.eazybi-jira/server/overview
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.