How would you create a report that shows SLAs that breached yesterday?

[e_wilber]

I must be overcomplicating this..

My employer wants to know all the incidents that had their SLAs breach yesterday, last week, and last month as 3 separate reports.

In looking at the inc_sla table I can see that we have Has Breached to indicate that it did infact breach, but there's no timestamp that I can see where I can only pull back incidents that breached yesterday (or last week).

How would I go about only displaying incidents that breached their SLA yesterday?

[AndersBGS]

Hi @e_wilber ,

You can just utilize below condition in the report designer:

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

Best regards

Anders