How to get list of Assignment groups that have not been used/assigned in a incident last 3 months

[DIMITRIS IORDAN]

How to get a list of Assignment groups that have not been used/assigned in a incident the last 3 months or in any specific duration? I have tried metrics but I cant seem to get the results that I want. Any ideas?

[JP - Kyndryl · Accepted solution]

Hi Dimitris,

I would use a Multi level pivot report on the incident_metric database view:

[DIMITRIS IORDAN]

Thats perfect, thank you!

[DIMITRIS IORDAN]

That's perfect, thank you!