How can I get the assigned tickets for the last 7 days and 30 days for each one on the same table

Ashraf Abu ALia
Kilo Explorer

find_real_file.png

2 REPLIES 2

AvinashDevadass
Tera Expert

You can create Indicators for each one and combine them using Indicator group with Assignment group as breakdown for all of them.

1) Create a Breakdown widget in dashboard

2) Enter the breakdown and Indicator group in that widget.

 

Regards

Avinash Devadass

Mark Becker
Giga Expert

I would wonder what you're trying to do with this visual. Do you have 6 managers each looking at different assignment groups (A through F)? If so I might create 4 individual single score reports with an Assignment Group filter on a Dashboard page.

However, the Assigned Today, 30 days, 7 days is interesting bc I'm not sure how I'd get to that information. You could use the Metric table to show Assigned To change but that wouldn't show first assigned to.

There might need to be an attribute added to the Incident table for 'last assigned date/time' and a business rule to change that every time assigned to is changed. Then you can create your reports based on that.

date/time stamp for when a ticket is assigned - IT Operations Management - Question - ServiceNow Com...

This shows how to create that 'Assigned at' field that you could report on in SNow.