how to view last 7 days ticket created counts on Jira dashboard

[Pravin Kamble]

how to view last 7 days ticket created counts on the Jira dashboard, So we can compare Today's count with all past 7 days tickets created.

[Kristján Geir Mathiesen · Accepted solution]

Hi @Pravin Kamble 

You can create a dynamic filter that shows issues created yesterday and save it, then use it in a dashboard gadget:

createdDate >= startOfDay(-1) AND createdDate <= endOfDay(-1)

Then create a dynamic filter that shows issues created the day before yesterday:

createdDate >= startOfDay(-2) AND createdDate <= endOfDay(-2)

And so on.

HTH,
KGM

[Pravin Kamble]

@Kristján Geir Mathiesen 

@Danut M _StonikByte_ 

Thank You for your valuable reply. 

I could see tickets for past dated now. But I have another query that how can we view tickets unassigned or unresolved count on Gadget' table wise, So we can see and compare  yesterday's counts on the table with today's real time counts .

eg. yesterday's unassigned tickets counts 100 VS Today's Unassigned tickets count say 200

Resolver Grp
                         10/09/23   11/09/23
L1Unassigned 100           200

[Kristján Geir Mathiesen]

Hi @Pravin Kamble  Like @Danut M _StonikByte_ said, either use a paid 3rd Party App or use a few free filters (one filter for each query, you can limit the results to just 1 issue but you'll still see how many issues are resulted).

HTH,
KGM

[Danut M _StonikByte_]

Hi @Pravin Kamble,

After you create two filters like the ones mentioned by @Kristján Geir Mathiesen, you can use the Advanced Issue Filter Formula gadget (or two Issue Filter Formula gadgets) to display the counts on your dashboard.

Clicking the numbers displayed on the gadget will open the filter behind, so you can see the actual issues.

These gadgets are offered by our Great Gadgets app. This app offers many other gadgets that you will find useful. To make an idea about how many things you can track with this app, take a look on our blog. 

If you have any questions, please don't hesitate to contact us at support@stonikbyte.com.

Thank you,

Danut Manda