How to Report Number of Incidents that breach SLA in a month.

Piyush Dwivedi
Tera Contributor

How to Report Number of Incidents that breach SLA in a month.

3 REPLIES 3

PratikshaKate
Kilo Guru

@Piyush Dwivedi 

Navigate to Reports and Create a New Report using new button.

Then select the data source: Choose "task_sla" as the data source. This table contains information about all tasks (including incidents) and their associated SLAs. 

apply filter : Task Type: Filter by "incident". 
Has Breached: Set this to "true" to only include incidents where the SLA has been breached. 
Breach Time (or Created): Filter by the specific month you are interested in (e.g., "Breach Time is between 2024-07-01 and 2024-07-31" for July 2024). 
Group the report by the "has breached" field. This will show you a count of incidents where the SLA was breached and where it was not breached.
Save the report and you can add it to the dashboard. 
 

AndersBGS
Tera Patron

Hi @Piyush Dwivedi ,

 

 just create a report based on the incident _sla database view that comes OOTB.

 

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/