how to query issues on the date that has the max count of certain status

demian kurejwowski

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

  

James Strangeway

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