Open topic with navigation

Change Task

Change Task iCube enables you to create ad hoc reports that help you analyze information related to Change Task.

Description

The left panel, titled, DASHBOARD DATA SETS contain the most common attributes and metrics used for analysis.

You can start your analysis in a variety of ways.  For example:

1. From the right panel, select a visualization type.  
   Each visualization automatically pulls in enough attributes and metrics to properly depict the chart type.
2. To achieve the desired analysis, from the DASHBOARD DATA SETS,drag-and-drop attributes or metrics.
   Alternatively, you can also begin the analysis by double-clicking the desired attributes and metrics from DASHBOARD DATA SETS to add these items into a grid in the visualization canvas. 
   Once you have added the desired attributes and metrics, in the right panel, you can change visualization to convert the grid into the desired chart type.
   Note: Some visualizations may require a minimum combination of attributes and metrics in order to deliver the expected results.
3. To remove a metric or an attribute, under the Visualization panel, right-click on the desired metric or attribute and click Remove.

Usage Example

The following examples illustrate one of the many analyses you can perform using the Change Task iCube :

If you want to find the Mean Open to Close duration for the change tasks, perform the below steps:

1. From the DASHBOARD DATA SETS panel,
   1. Double-click Change Task attribute to add it to the grid.
   2. Double-click the Mean Open to Close Duration (Days) metric to add to the grid.

Note: You can also drag the metrics and attributes and drop them on the Visualization column or under the Visualization 1 (blank page) to add them to the grid.

2. To change the grid to a chart, in the right panel, from the visualization options, select Bar Chart.
3. Now drag the metrics and drop them to the Color By section to apply colors to the metric values in the chart.

Tip: You can customize the view of any particular parameter by right-clicking the parameter and modifying to the required format.

Attributes

Expand this link to view the Change Task iCube attributes and their descriptions:

Attribute Name	Description
Application	Name of the application
Approval	Approval status for the Change Task
Assigned To	Person primarily working on the Change Task
Assigned To Manager	Manager of the person primarily working on the Change Task
Assignment Group	Group/team primarily responsible for working on the Change Task
Assignment Group Manager	Manager of the group/team of the people primarily responsible for working on the Change Task
Backlog Flag	Flag to indicate if the Change Task is Open or Closed
Business Service	Affected Business Service
Calendar Date	Gregorian calendar date
Change	Unique identifier for the Change Request
Change Assignment Group	Group/team primarily responsible for working on the Change to which Change Task belongs
Change Close Code	Code to indicate if the Change was "Successful", "Successful with issues", or "Unsuccessful"
Change Closed Date	Date on which the Change Request was closed
Change Number	Unique identifier (number) for the Change Request to which Change Task belongs
Change On Hold Flag	Flag to indicate if the Change Request is on hold
Change Opened Date	Date on which the Change Request was opened
Change Phase	Phase of the Change Request
Change Phase State	Phase state of the Change Request
Change Priority	Priority for the Change Task
Change State	State of the Change Request
Change Task	Unique identifier for the Change Task
Change Task Location	Location of the affected caller or service
Change Task Number	Unique identifier of the Change Task
Closed By	Person who closed the Change Task
Closed Date	Date on which the Change Task is closed
Configuration Item	CI associated with the Change Task
Contact Type	Medium through with Change Task was reported
Date	Gregorian calendar date displayed in the format 'MM/DD/YYYY'
Dormant Flag	Flag to indicate if the Change Task is dormant
Due Date	Date on which the Change Request is due for completion
Employee	For Opened Change Tasks, person who has opened the Change Task For Closed Change Tasks, person who has closed the Change Task
Impact	Impact of the Change Task
Met Sla Flag	Flag to indicate if the SLA for the Change Task is met
Opened By	Person who opened the Change Task
Opened Date	Date on which the Change Task was opened
Overdue Flag	Flag to indicate if the Change Task is overdue
Priority	Priority for the Change Task
Short Description	Short description for the Change Task
State	State of the Change Task
Task Type	The task type of the Change Task
Type	Change Request type
Urgency	Urgency of the Change Task

Metrics

Expand this link to view the Change Task iCube metrics and their descriptions:

Metric Name	Description	Formula	Expected values
Age of Parent at Change Task Closure (Days)	The age of the parent Change Request in days, when the corresponding child Change Task was closed	Sum (([Parent Age at Task Closure] / 86400))	0 or >0
Age of Parent at Change Task Open (Days)	The age of the parent Change Request, in days, when the corresponding child Change Task was opened	Sum(([Parent Age at Task Open] / 86400))	0 or >0
Avg Age (Days)	The average age of the Change Task. This metric is calculated as the (sum of Change Task age across all opened Change Tasks) divided by (number of opened Change Tasks). Change task age is the time taken, in days, since the creation of the Change Task	[Change Task Age (Days)] / [Opened Change Tasks]	0 or >0
Avg Approval Duration (Days)	The average approval duration for the change task. Approval duration is the time taken for the Change Task to be approved. This metric is calculated as the (sum of Change Task approval duration across Approved Change Task) divided by (Number of approved Change Tasks)	[Change Task Approval Duration (Days)] / [Approved Change Tasks]	0 or >0
Avg Days since Last Update	Average number of days since the last update for currently open Change Tasks This metric is calculated as the (sum of Days since last update across all Open Change Tasks) divided by (number of Open Change Tasks).	[Change Task Days since Last Update] / [Change Task Backlog]	>0
Avg Overdue Duration (Days)	Average time taken by Change tasks beyond the specified due date. This metric is calculated as the (sum of days beyond due date for overdue Change tasks) divided by (number of overdue Change tasks).	[Change Task Overdue Duration (Days)] / [Overdue Change Tasks]	>0, Closer to 0 is ideal
Avg Reassignment Count	Avg number of reassignments across all Opened Change Tasks Metric is calculated as the (number of reassigned change tasks) divided by (number of opened change tasks)	[Change Task Reassignment Count] / [Opened Change Tasks]	>=0
Avg Time Worked (Days)	Average time spent per Change Task. This metric is calculated as the (total time spent on the Change tasks) divided by (number of closed Change tasks)	[Change Task Time Worked (Days)] / [Closed Change Tasks]	>0, Closer to 0 is ideal
Avg Update Count	Average number of updates per Change Task. This metric is calculated as the (Number of updates across opened Change Tasks) divided by the (Number of opened Problem Tasks)	[Change Task Update Count] / [Opened Change Tasks]	>0, Closer to 0 is ideal
Business Duration (Days)	Total business time taken for the given Change Tasks to move from open to closed state	Sum(([Business Duration] / 86400))	>=0
Change Task Backlog	Number of Change Tasks that are currently in the "Open" state	Count([Opened Change Tasks])[Change Task Backlog]>	0 or >0
Closed Change Tasks	The total number of Change Tasks that have been closed	Count([Closed Change Tasks])	>=0
Days since Last Update	Number of days between today and last updated date for the given Change Task	Sum(([Dormancy Age] / 86400))[Change Task Backlog]	>0
Mean Open to Close Duration (Days)	Average time for closure of a Change Task. This metric is calculated as the sum of time duration taken to close Change tasks divided by the number of closedChange Tasks.	[Change Task Open To Close Duration (Days)] / [Closed Change Tasks]	0 or >0, closer to 0 is ideal
Open To Close Duration (Days)	Number of days taken for a Change Task to move from 'Open' state to 'Close' state.	Sum (([Open To Close Duration] / 86400))	>=0
Opened Change Tasks	Count of the total number of Change Tasks that have been opened so far.	Count([Opened Change Tasks])	>=0
Overdue Change Tasks	Count of Change Tasks that are overdue	Count([Opened Change Tasks])[Change Task Overdue]	>=0
Reassignment Count	Count of the number of times a Change Task has been reassigned between assignment groups.	Sum([Change Task Reassignment Count])	>=0
Update Count	Total number of times a Change Task was updated.	Sum([Change Task Update Count])	>=0