The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

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

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

TAGS
AUG Leaders

Atlassian Community Events