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.