How to generate number of breach incident report?

[Siti]

Hello there,

I am new in ServiceNow but I have requirement from Management where they are looking for number of breach incident MTD and YTD.

I tried to use Task_SLA table and Incident_SLA table but looks like it will provide the number of task_sla instead of number of incidents.

I also found made SLA column in incident table but I think this column is useless.

Is there any way for the to get this done without concern about how many number of task_SLA?

example : total incidents MTD is 100.

                has breach :5,not breach 95.

Any idea are welcome.

Thanks in advance.

[Slawek_Radziewi]

You are using distinct count which do the job when you're not stacking. 

However, when you are stacking and distinct SLA has breached might be false or true (just check your list) so they will be counted twice.