JQL or filter recommendation to create a report that refreshes monthly automatically

[Brian]

I would like to create a filter that displays the top 3 of "x" field where a certain ticket type is logged.  I would also like the filter to refresh on it's own on a monthly basis to capture what has been logged for those top 3 fields.   

Use case with variable examples: 

we have 100 apps and over a month 3000 tickets are opened.  the top 3 apps have 70, 79, and 100 tickets opened for them in the past month.  What JQL or filter approach can i use to display those top 3?  And is there a wildcard JQL where the filters knows to move on to next month once we hit the respective next month?  

[Florian Bonniec · Accepted solution]

Hi @Brian 

You could create a filter that list all the ticket created during the last month.

project in (XX, YY) and type in (AA) and created >= startOfMonth(-1) and created created < endOfMonth(-1)

Then you can create gadget in a dashboard to group value by a field like two dimensional gadget.

Regards

[Brian]

thanks for the suggestions, this should work. have updated JQL and touching up the gadget now. Thank you!