How can I create ticket ageing report based on ticket creation date eg: 10 tickets 7 days old, 20 tickets 8-14 days old etc

[Deleted user]

I would like to be able to create a ticket ageing report based on the creation date of a ticket i.e. total number of unresolved tickets broken into ageing buckets: 1 – 7 days, 8 – 14 days, 15 – 21 days, 22 – 28 days, 29+ days

1 – 7 days : 25 tickets

8 – 14 days : 7 tickets

15 – 21 days : 5 tickets

22 – 28 days : 3 tickets

29+ days : 30 tickets

Any help would be greatly appreciated

Thanks

John

aging bucket report.png

[Peter Bengov · Accepted solution]

Hey John,

If you have Confluence as well and it is linked to JIRA, this will be very simple to do using the JIRA macro. Create a new Confluence page, add a JIRA macro and query something like this:

project = "relevant project" AND created >= startOfWeek() and created < endOfWeek()

Now this macro has the Display options. Click on it then click on Total issue count. Save

Repeat this with different queries just add relevant numbering like startOfWeek(-1) (for previous week) and startOfWeek(-2) for two weeks ago, and so on.

Hope this helps you out.

[Brian Vent]

this didn't work for me, unsure why.  Tried countless variations

[Naagesh Setty]

Hi I wanted to make filter for closed defects which are closed More than 5 days. Like defect closed date - created date. 

With one condition defects closed date >= startoftheweek()

[MOHAMMED_ASHRAF_ALI]

Do we have a report which can help with:

Post assigning ticket - if user has not taken action for a day or 2 then the report track these tickets basis update status 

[Deleted user]

This is AWESOME! ! ! ! 

Mucho Thanks!

(Oh, and delete the pand in the example)

[Deleted user]

Hi Peter,

This is perfect.  Thank you so much for your quick reply.

Cheers

John