JQL Group By function

[Subhrangshu Choudhury]

Hello,

I am trying to generate a report from JIRA which can show me defects raised every month. Say month January I have 10 defects and in month February I have 7 defects.

I want the JQL to give me a report as below:

JAN 10

FEB  07

and so on...

Please let me know if this is possible in a single query to filter all the defects count for all the months.

Regards

Subhrangshu

[Nic Brough -Adaptavist- · Accepted solution]

JQL (filtering) and reporting are two separate things.

JQL / filters find issues.  That's it.  They have nothing to say about how they are displayed or reported on.  That's up to the reports you use them in.  You can easily filter for "issues per month", because you can use things like "created > startofmonth(x) and created < endofmonth(x)", but the JQL for "all issues I want to see" is simply going to give you all the issues.  The JQL cannot have anything to say about grouping the results up because it is just a search.

The only way I can think of doing this is for you to create one filter for each month, and then put each filter in its own gadget on a dashboard.

[Subhrangshu Choudhury]

Thanks Nic for the reply. I got your point when you say JQL and reporting are two separate things. But now as I have a suggestion as you mentioned to filter for each month separately and then put them on a gadget.

Just wanted to know, is it possible to put each filter result in a single gadget (or what ever) which can show the data like a report. May be, if we create a page in Confluence where we select each filter (for each month) and see the result in a single sheet/ gadget/ what ever  that can show the best output.

Thanks

Subhrangshu