Open topic with navigation

Request Task State Change

Request Task State Change iCube enables you to create ad-hoc reports that help you analyze information related to the various states that a Change progresses through and the time duration in each of these states.

Description

The left panel, titled DASHBOARD DATA SETS contains 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 Catalog Task State Change iCube :

If you want to determine the average of the number of state changes that each of the catalog task has been through, perform the following steps:

1. From the DASHBOARD DATA SETS panel,
   1. Double-click CatalogTask Number attribute to add it to the grid.
   2. Double-click the Avg State Change Count 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 view of any particular parameter, right-click the parameter and modify to the required format.

Attributes

Expand this link to view the Request Task State Change iCube attributes:

Attribute Name	Description
Actual End Date	Date on which work on the Request Task actually ended
Actual Start Date	Date on which work on the Request Task actually started
Approval	Approval status for the Request - Not Yet Requested, Requested, Approved, or Rejected
Assigned To	Person primarily responsible for working on the Request Task State Change
Assigned To Manager	Manager of the person primarily responsible for working on the Request Task
Assignment Group	Group or team of the person primarily responsible for working on the Request Task
Assignment Group Manager	Manager of the group to which the person working on the Request Task belongs
Closed Date	Gregorian calendar date on which Request Task was closed
Configuration Item	Configuration Item associated with the Request Task
Current State	Current State of the Request Task State Change
Due Date	Date on which the Request Task is due
Next State	State to which the Request Task will be changed
Opened Date	Gregorian calendar date on which Request Task is opened
Priority	Priority level for resolving the request task
Request Item (RITM) Number	Unique identifier number for the RITM
Request Number	Unique number for the request
Request Task Number	Unique identifier of the request task
RITM Stage	Stage of the Request Task State Change
RITM State	State of the Request Task State Change
Short Description	Short description about the request at the source system
State	State of the Request Task State Change
State Change Count	Number of times the State has changed for a Request Task
State Change Date	Date on which the State has changed for a Request Task
State Sequence Number	Sequence in which the State has changed for a particular Request Task
Upon Approval	Next Action upon Approval of the Request Task

Metrics

Expand this link to view the Request Task State Change iCube metrics:

Metric Name	Description	Formula	Expected Values
Avg State Change Count	Displays the average count of the state changes across all catalog tasks.	Max([Request Task State Count Fact]){~+}	>0
Avg State Duration (Days)	Displays an average of the time taken by a catalog task in a particular state.	[Request Task State Duration (Days)] / [Request Task Count from Activity]	0 or>0
Max Duration for State (Days)	Displays the maximum duration of a state that a catalog task has been in. This metric is measured at the State level and provides the maximum duration of a state across all the catalog tasks.	Max([Request Task State Duration Fact]) / 86400{[Request Task From State (Source)]+}	0 or>0
Min Duration for State (Days)	Displays the minimum duration of a state that a catalog task has been in. This metric is measured at the State level and provides the minimum duration of a state across all the catalog tasks.	Min ([Request Task State Duration Fact]) / 86400{[Request Task From State (Source)]+}	0 or>0
State Change Count {Catalog Task Number}	Displays the number of state changes across all catalog tasks.	Max ([Request Task State Count Fact]){[Request Task Number]+}	0 or >0
State Duration (Days)	Displays the total time taken by a catalog task in a particular state.	Sum([Request Task State Duration Fact]) / 86400{~+}	0 or>0