Audi log history check. I need a report of incidents that have ever had a given status set

Content

Hello,

I was asked to find a way to create a report that checks incidents history and returns a list of incidents that in the past have had certain status assigned (even if that status is not the current status).

The idea is to get the number of incidents that were Escalated to managers or supervisors in a given month (or any period of time).

The current status of the incidents might be "solved" or anything else, but at some point in the past were assigned the status Escalate.

 

I hope that made sense and somebody can help me with it...