create a report on incident with p1 or the priority was previously p1

[mregragui_ext]

Hello everyone, I need to create a report on incident with p1 or the priority was p1 and has been downgrade to p2 ..

[Mark Roethof]

Hi there,

How are you making sure that for every record there is History and History Lines? Because that's not auto populated for all records immediately out-of-the-box. Following this approach of reporting, would cause an incorrect data set. Unless auto populating the History and History Lines is somehow done.

[Aman Kumar S]

Hi Mark,

I understand this is not the best approach out there, but one possible way to achieve it.

And I believe your response already covered that ground.

Metrics and PA is the way to go, but History can also be a feasible solution.

[Mark Roethof]

No that's not what I'm after.

What I'm mentioning is yes you can look at History and History Line, though... when are those populated? Only if someone clicks manually on History > List. So if no one clicks on that on a task (which no one will for the majority of the tasks), the History and History Lines are not generated. So at what data are you really looking at than, a by far incomplete data set.

[mregragui_ext]

i have tried this. not giving me the info i want

[AndersBGS]

Hi @mregragui_ext ,

first create a metric in metric definition for priority is P1. This refer to, that every time an incident is p1, a metric record will be created.

secondly, create a report based on the metric definition with the condition that priority is not P1. This will show you all incidents which have been P1 but is no longer P1.

if my answer has helped with your question, please mark answer as accepted solution and give a thumb up.

Best regards

Anders