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 March 19, 2015

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

 

 

4 answers

1 accepted

3 votes
Answer accepted
Peter Bengov
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 19, 2015

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 December 2, 2018

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

Naagesh Setty March 7, 2020

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()

0 votes
MOHAMMED_ASHRAF_ALI June 21, 2019

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 

0 votes
Deleted user August 6, 2015

This is AWESOME! ! ! ! 

 

Mucho Thanks!

(Oh, and delete the pand in the example)

0 votes
Deleted user March 19, 2015

Hi Peter,

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

Cheers

John

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events