Need help . What would be JQL query to display Issue count by Severity with date?

[Bala Yadlapalli]

Need help . What would be JQL query to display Issue count by Severity with date

[John Funk]

Hi Bala,

You might try creating your filter and then display the results in a Dashboard gadget like the Issue Statistics gadget or the Two Dimensional gadget. 

[Rob Horan]

The problem with this approach is needing a new filter for every date

[Rob Horan]

Jira queries return issues, not issue counts.  What you're looking for is a report - one that very likely would require a 3rd party reporting tool.

[Bala Yadlapalli]

Thank you.  Don't we have reporting feature on JIRA?

[Nic Brough -Adaptavist-]

Loads, and most of them rely on JQL for the data feed - you define a filter that returns a list of issues you want to report on, and then feed it into the report (see the project reports, the board reports and the service desk reports sections) or the dashboard gadget(s) that can represent the data from the issues in loads of different ways.

[Rob Horan]

But which out of the box report would offer a date-based breakdown so that you get a # of issues by severity on a given day?    Wouldn't the OP need to create a new filter per day?

[Nic Brough -Adaptavist-]

Could do a string of dynamic ones - yesterday, yesterday - 1, yesterday -2 etc.  But also, we don't know what the "with date" really means - what is it trying to report on?

Maybe the opened vs resolved chart (one per severity?) might be of use.  Or even swap to priority and use a calendar gadget. There's quite a lot of options as to what this date might be.

I'd revert to the usual - what is the actual question being asked here?  What do you want the report to tell your users?