Show all on Hold Incidents historically

[Fabian Mattheis]

Hi everybody,

I need help with reporting on Incidents. I need to build a report which shows how many incidents have been on hold and had the on hold reason "Awaiting Vendor" on a specific date in the past.

I tried it with the sys_audit table and also created a metric for this but I'm not sure how to properly report on it.

My problem is that I need to show all incidents on a timeline that have been on hold on this day (but are now closed or in another state). Till now I only managed to report on how many incidents were put to this specific state on a day, but not all of the incidents that were already on hold till this day.

I someone could help, it would be great.

Greetings

Fabian

[Adam Stout]

Are you looking for a cumulative number of incidents that have ever been on hold or incident that were on hold on at any point in the day on a given day?

[Fabian Mattheis]

The second option would be the right report for me.

I need a timeline report that shows the on hold incidents for every day in the past. The Problem is, that most of these incidents are no longer on hold today but were on hold for maybe 4 days in the past.

[Adam Stout]

I would think you could do this with PA with a job that looked at the metrics to see anyone that had an active metric record that showed on-hold that started at or before today and ended at or after today (or was still active).