We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Help Needed with Incident Aging Pivot Report Structure

SidduChittaragi
Tera Contributor

Hi Community,

I tried implementing Incident Aging and was able to include the Aging field in the report.

However, I have a slightly different requirement. Along with Aging, I also need to display Priority and State separately in the report. Currently, when I add them, they get stacked/grouped hierarchically (Assignment Group → Priority → State) in the Pivot report as shown below.
SS1.png

What I’m trying to achieve is a flat structure similar to below:

Assignment Group | Priority | State | 0–3 days | 3–7 days | 7–15 days | 15–30 days | 30+ days - Please Refer below SS
SS2.png

Instead of Priority and State getting nested/grouped under Assignment Group.

Is there a way to achieve this in ServiceNow reports?

Thanks!

0 REPLIES 0