ITSM KPI Repository
G
Written by Gary Ditsch
Updated over a week ago

30-Day Incident KPIs

Count of incidents opened in the last 30 days.

=VIVIDCOUNT(incident, opened_atONLast 30 days@javascript:gs.beginningOfLast30Days()@javascript:gs.endOfLast30Days())

Count of incidents opened in the last 30 days and resolved in 5 days or less.

=VIVIDCOUNT(incident, opened_atONLast 30 days@javascript:gs.beginningOfLast30Days()@javascript:gs.endOfLast30Days()^resolved_atLESSTHANopened_at@day@after@5)

Count of incidents opened in the last 30 days and resolved on the same day.

=VIVIDCOUNT(incident, opened_atONLast 30 days@javascript:gs.beginningOfLast30Days()@javascript:gs.endOfLast30Days()^resolved_atSAMEASopened_at@day)

Count of incidents opened in the last 30 days and supported by a knowledge base article.

=VIVIDCOUNTDIST(m2m_kb_task, taskSTARTSWITHINC^sys_created_onONLast 30 days@javascript:gs.beginningOfLast30Days()@javascript:gs.endOfLast30Days(), task)

7-Day Incident KPIs

Count of incidents opened in last 7 days

=VIVIDCOUNT(incident, opened_atONLast 7days@javascript:gs.beginningOfLast7Days()@javascript:gs.endOfLast7Days())

Count of incidents opened in the last 7 days and resolved in 5 days or less.

=VIVIDCOUNT(incident, opened_atONLast 7 days@javascript:gs.beginningOfLast7Days()@javascript:gs.endOfLast7Days()^resolved_atLESSTHANopened_at@day@after@5)

Count of incidents opened in the last 7 days and resolved on the same day

=VIVIDCOUNT(incident, opened_atONLast 7 days@javascript:gs.beginningOfLast7Days()@javascript:gs.endOfLast7Days()^resolved_atSAMEASopened_at@day)

This Week's Incident KPIs

Count of major incidents caused by failed change this week.

=VIVIDCOUNT(incident, opened_atONThis week@javascript:gs.beginningOfThisWeek()@javascript:gs.endOfThisWeek()^major_incident_state=accepted^caused_byISNOTEMPTY)

Last Week's Incident KPIs

Count of major incidents caused by failed change last week.

=VIVIDCOUNT(incident, opened_atONLast week@javascript:gs.beginningOfLastWeek()@javascript:gs.endOfLastWeek()^major_incident_state=accepted^caused_byISNOTEMPTY)

This Year's Incident KPIs

Count of major incidents caused by failed change this year.

=VIVIDCOUNT(incident, opened_atONThis year@javascript:gs.beginningOfThisYear()@javascript:gs.endOfThisYear()^major_incident_state=accepted^caused_byISNOTEMPTY)

Did this answer your question?