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

Question

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 Answer

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