Incident - Chart Templates
G
Written by Gary Ditsch
Updated over a week ago

1.

Title: Open Incidents

Table: incident

Chart Type: Score

Aggregate Type: Count

Conditions:

active=true

2.

Title: Critical Open Incidents

Table: incident

Chart Type: Score

Aggregate Type: Count

Conditions:

active=true^priority=1

3.

Title: Overdue Incidents

Table: incident

Chart Type: Score

Aggregate Type: Count

Conditions:

active=true^escalation=3

4.

Title: Incidents Older Than 30 Days

Table: incident

Chart Type: Score

Aggregate Type: Count

Conditions:

active=true^opened_atRELATIVELE@dayofweek@ago@30

5.

Title: Incidents Open Today

Table: incident

Chart Type: Score

Aggregate Type: Count

Conditions:

opened_atONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()

6.

Title: Open P1 Incidents

Table: incident

Chart Type: Score

Aggregate Type: Count

Conditions:

priority=1^resolved_atISEMPTY^active=true

7.

Title: Incidents Not Updated in 7 Days

Table: incident

Chart Type: Score

Aggregate Type: Count

Conditions:

active=true^sys_updated_onRELATIVELE@dayofweek@ago@7

8.

Title: Incidents Average Reassignments

Table: incident

Chart Type: Score

Aggregate Type: Average

Aggregate Field: reassignment count

Conditions:

active=true

9.

Title: Unassigned Incidents

Table: incident

Chart Type: Score

Aggregate Type: Count

Conditions:

active=true^assigned_toISEMPTY

10.

Title: Open Incidents by Priority

Table: incident

Chart Type: Donut

Aggregate Type: Count

Group by: Priority

Legend: bottom middle

Conditions:

active=true

11.

Title: Open Incidents by State

Table: incident

Chart Type: Donut

Aggregate Type: Count

Group by: State

Legend: bottom middle

Conditions:

active=true

12.

Title: Open Incidents by Category

Table: incident

Chart Type: Donut

Aggregate Type: Count

Group by: Category

Legend: bottom middle

Conditions:

active=true

13.

Title: Incidents Opened per Week

Table: incident

Chart Type: Line

Date Query: Opened on this year

Aggregate Type: Count

Trend field: opened

Trend type: week

Conditions:


14.

Title: Incidents Closed per Week

Table: incident

Chart Type: Line

Date Query: Closed on this year

Aggregate Type: Count

Trend field: opened

Trend type: week

Conditions:

active=false

15.

Title: Open Incidents Older Than 30 Days by Priority

Table: incident

Chart Type: Horizontal Bar

Aggregate Type: Count

Group by: Priority

Conditions:

active=true^opened_at<=javascript:gs.beginningOfLast30Days()

16.

Title: Open Incidents by Assignment

Table: incident

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: Assigned to

Limit: 10

Conditions:

active=true

17.

Title: Opened Incidents This Month by Priority

Table: incident

Chart Type: Vertical Bar

Date Query: Opened on this month

Aggregate Type: Count

Group by: Priority

Conditions:


18.

Title: Closed Incidents This Month by Category

Table: incident

Chart Type: Vertical Bar

Date Query: Closed on this month

Aggregate Type: Count

Group by: Category

Conditions:


19.

Title: All Incidents by Location

Table: incident

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: Location

Limit: 10

Conditions:


20.

Title: All Incidents by Assignment

Table: incident

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: Assigned to

Limit: 10

Conditions:


21.

Title: All Incidents by Category

Table: incident

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: Category

Limit: 10

Conditions:


22.

Title: Inactive Incidents by Closed By

Table: incident

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: Closed by

Limit: 10

Conditions:

active=false

23.

Title: Open Incidents by Escalation

Table: incident

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: Escalation

Limit: 10

Conditions:

active=true

24.

Title: Open Incidents by State

Table: incident

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: State

Limit: 10

Conditions:

active=true

25.

Title: Open Incidents by Category

Table: incident

Chart Type: Vertical Bar

Aggregate Type: Count

Group by: Category

Conditions:

active=true

Did this answer your question?