Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

I'm busy creating an Age analysis report? How do I get counts <30d, 60d, 90d and >120d

Theresa Dreyer
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 2, 2021

hello, please can someone help me.  

I'm creating a age analysis report and I need my Service desk report to display the tickets logged < less than 30 days, between 31 - 60 days, between 61 - 90 days, between 91 - 120days then > 120 days.

This is what I have, but my counts are not correct on the 31 - 60 days ?

issuetype = Problem AND status in ("Work in progress", Open, Pending, "Under investigation", "Under review") AND created >= -30d AND created <= now()

 

issuetype = Problem AND status in ("Work in progress", Open, Pending, "Under investigation", "Under review") AND created <= startOfDay(-31d) AND created >= startOfday(-60d)

 

issuetype = Problem AND status in
("Work in progress", Open, Pending, "Under investigation", "Under review")
AND created < startOfMonth(-1) AND created > startOfMonth(-2)

 

issuetype = Problem AND status in ("Work in progress", Open, Pending, "Under investigation", "Under review") AND created < startOfMonth(-2) AND created > startOfMonth(-3)

 

issuetype = Problem AND status in ("Work in progress", Open, Pending, "Under investigation", "Under review") AND created < startOfMonth(-3)

Much appreciated.image.pngimage.png

 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events