1.
Title: Change by Month
Table: change_request
Chart Type: Timed Bar
Aggregate Type: Count
Trend by: Month
Conditions:
opened_atONLast 12 months@javascript:gs.beginningOfLast12Months()@javascript:gs.endOfLast12Months()
2.
Title: Overdue Changes
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
active=true^end_date<javascript:gs.beginningOfToday()
3.
Title: Open Critical Changes
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
active=true^priority=1
4.
Title: Conflicting Changes
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
active=true^conflict_status=Conflict
5.
Title: Rejected Changes
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
active=true^approval=rejected
6.
Title: Today's Emergency Changes
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
active=true^type=emergency^start_dateONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()^state!=-5
7.
Title: Unassigned Changes
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
active=true^assigned_toISEMPTY
8.
Title: Changes Awaiting Approval
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
active=true^state=-4
9.
Title: Today's High Risk Changes
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
active=true^start_dateONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()^state=-2^ORstate=-1^risk=2
10.
Title: Changes On Hold
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
active=true^on_hold=true
11.
Title: Changes Opened Today
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
active=true^opened_atONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()
12.
Title: Open Changes by Category
Table: change_request
Chart Type: Donut
Aggregate Type: Count
Group by: Category
Legend: bottom middle
Conditions:
active=true
13.
Title: Standard Changes Success
Table: change_request
Chart Type: Donut
Aggregate Type: Count
Group by: Close code
Legend: bottom middle
Conditions:
type=standard^active=false
14.
Title: Open Changes by Escalation
Table: change_request
Chart Type: Donut
Aggregate Type: Count
Group by: Escalation
Legend: bottom middle
Conditions:
active=true
15.
Title: Open Changes by Priority
Table: change_request
Chart Type: Horizontal Bar
Aggregate Type: Count
Group by: Priority
Conditions:
active=true
16.
Title: Open Changes by State
Table: change_request
Chart Type: Vertical Bar
Aggregate Type: Count
Group by: State
Conditions:
active=true
17.
Title: Open Changes by Risk
Table: change_request
Chart Type: Vertical Bar
Aggregate Type: Count
Group by: Risk
Conditions:
active=true
18.
Title: Emergency Changes - Last 7 Days
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
type=emergency^work_startONLast 7 days@javascript:gs.beginningOfLast7Days()@javascript:gs.endOfLast7Days()
19.
Title: Normal Changes - Last 7 Days
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
type=normal^work_startONLast 7 days@javascript:gs.beginningOfLast7Days()@javascript:gs.endOfLast7Days()
20.
Title: Standard Changes - Last 7 Days
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
type=normal^work_startONLast 7 days@javascript:gs.beginningOfLast7Days()@javascript:gs.endOfLast7Days()
21.
Title: Changes - Last 7 Days
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
work_startONLast 7 days@javascript:gs.beginningOfLast7Days()@javascript:gs.endOfLast7Days()
22.
Title: Critical Changes - Last 7 Days
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
priority=1^work_startONLast 7 days@javascript:gs.beginningOfLast7Days()@javascript:gs.endOfLast7Days()
23.
Title: Failed Changes - Last 7 Days
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
close_code=unsuccessful^work_startONLast 7 days@javascript:gs.beginningOfLast7Days()@javascript:gs.endOfLast7Days()
24.
Title: Changes by Priority - Last 7 Days
Table: change_request
Chart Type: Donut
Aggregate Type: Count
Group by: Priority
Conditions:
work_startONLast 7 days@javascript:gs.beginningOfLast7Days()@javascript:gs.endOfLast7Days()
25.
Title: Changes by Type - Last 7 Days
Table: change_request
Chart Type: Donut
Aggregate Type: Count
Group by: Type
Conditions:
work_startONLast 7 days@javascript:gs.beginningOfLast7Days()@javascript:gs.endOfLast7Days()
26.
Title: Standard Changes - Next Week
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
type=standard^start_dateONNext week@javascript:gs.beginningOfNextWeek()@javascript:gs.endOfNextWeek()
27.
Title: Changes - Next Week
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
start_dateONNext week@javascript:gs.beginningOfNextWeek()@javascript:gs.endOfNextWeek()
28.
Title: Critical Change - Next Week
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
priority=1^start_dateONNext week@javascript:gs.beginningOfNextWeek()@javascript:gs.endOfNextWeek()
29.
Title: Standard Changes - This Week
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
type=standard^start_dateONThis week@javascript:gs.beginningOfThisWeek()@javascript:gs.endOfThisWeek()
30.
Title: Changes - This Week
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
start_dateONThis week@javascript:gs.beginningOfThisWeek()@javascript:gs.endOfThisWeek()
31.
Title: Critical Changes - This Week
Table: change_request
Chart Type: Score
Aggregate Type: Count
Conditions:
priority=1^start_dateONThis week@javascript:gs.beginningOfThisWeek()@javascript:gs.endOfThisWeek()