Dahboard and graphs

[Giuseppe Terrasi]

Could someone please help me with this?

QUESTION 1

Hi I'm trying to create the following reports using custom filters and dashboard's widgets, but I'm having some difficulties.

Opened bugs for the last month grouped by project
Closed bugs for the last month grouped by project
Opened vs Closed bugs for the last month grouped by project
Average bug resolution time for the last month grouped by project

It seems that I can't create such specific reports, can I?
If yes, could you please address me to the detailed docs? I already tried unsuccessfully for half a day.
Thanks a lot

———————
ANSWER FROM JIRA COMMUNITY MEMBER
Hi @Giuseppe Terrasi - You cannot do grouping inside of JQL (the filter) directly, but you can get there using the Dashboard gadget called Issue Statistics.
Add the Issue Statistics gadget to your dashboard, then connect it to the Opened Bugs for the last month filter.
Then choose Project for the Issue statistic field. Be sure to check whether you want issues that have been closed or not.
That should get you want you want.
Do the same for each of your other filters using the same type of gadget.
I hope that helps!

———————
QUESTION 2
Hi John,
Thanks, but how do I do a filter which can get me results just for the last month and that updates itself automatically every new month?
In November I need to look at the opened bugs for October, in December the graph should updates itself and show the results for November and so on, all without any manual intervention from my side.
Is this possible? With this, I'll solve all my issues.

[Iago Docando · Accepted solution]

I'll address each of your comments separately. The grouping by project is tricky and not easily obteineable for everything you want to know.

• how do I do a filter which can get me results just for the last month and that updates itself automatically every new month?

startOfMonth(), endOfMonth(), etc. search in the current month. startOfMonth(-1) searches in last month so there you have your solution ;) You could also use (-2), (-3), and so on if you ever need it. Every time function works like that.

• Opened bugs for the last month grouped by project & Closed bugs for the last month grouped by project

This seems trivial. I believe vanilla Jira comes with a gadget called "bidimensional statistics" or something similar. You just have to creat a JQL filter similar to "issuetype=bug & createdDate>=startOfMonth(-1) & createdDate>=endOfMonth(-1)". Your axis will be STATUS and PROJECT.

To have in mind: You'll get a count of the issues in EACH EXISTING STATUS, not just open or closed.  Also, maybe you need to think a bit on the time condition. Maybe you want to use worklogDate or whatever suits your needs.

• Opened vs Closed bugs for the last month grouped by project

To my knowledge, you'll have to resort to use one gadget per proyect but the gadget type itself also comes out of the box with jira. You just need to edit the configuration and choose your date options.

• Average bug resolution time for the last month grouped by project

Again, you'll have to use one report per project but it comes by default in the reports screen of each project.