Open topic with navigation

Request Item State Change

Request Item 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 Request Item State Change iCube:

If you want to determine the number of state changes of each of the request item based on the state duration, perform the following steps:

  1. From the DASHBOARD DATA SETS panel,
    1. Double-click State Change Count attribute to add it to the grid.
    2. Double-click Request Item Number attribute to add it to the grid.
    3. Double-click the State 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.

  1. To change the grid to a chart, in the right panel, from the visualization options, select Bar Chart.
  2. 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

ClosedExpand this link to view the Request Item State Change iCube attributes:
Attributes Description
Assigned To Person primarily responsible for working on the Request
Assigned To Manager Manager of the person primarily responsible for working on the Request
Assignment Group Group or team of the person primarily responsible for working on the Request Item
Assignment Group Manager Manager of the group to which the assignee belongs
Closed Date Date on which the Request was closed
Configuration Item Configuration Item related to the request
Current Stage Current Stage of the Request Task
Current State Current State of the Request Task
Department Department associated with the Request Task
Due Date Date on which the Request is due
Item Name of the requested Item
Next Stage The stage to which the Request Task will be changed
Next State The state to which the Request Task will be changed
Opened Date Gregorian calendar date on which Request is opened
Priority Priority level for resolving the request
Request Identifier for the Request
Request Item Identifier for the Request Item
Request Item Number Unique identifier number for the Request Item
Request Number Unique identifier number for the Request
Short Description Short description about the Request Item at the source system
Stage Stage of the Request Item
Stage Change Count Number of times the Stage of the Request Item has changed
Stage Sequence Number Sequence in which the Stage has changed for a particular Request Item
State State of the Request Item
State Change Count Number of times the State has changed for a Request Item
State Sequence Number Sequence in which the State has changed for a particular Request Item
State/Stage Change Date Date when the Stage or State of the Request Item last changed

Metrics

ClosedExpand this link to view the Request Item State Change iCube metrics:
Metric Name Description Formula Expected Values
Avg Stage Change Count Displays the average count of the stage changes that a request item has been through. Max([Avg Request Item Stage Change Count]){~+} >=0
Avg Stage Duration (Days) Displays an average of the time taken by a request item in a particular stage. [Request Item State Duration (Days)] / [Request Item Count for State Activity] 0 or >0
Avg State Change Count Displays the average count of the state changes that a request item has been through. Max([Avg Request Item State Change Count]){~+} 0 or >0 Closer to 0 is better
Avg State Duration (Days) Displays an average of the time taken by a request item in a particular state. [Request Item State Duration (Days)] / [Request Item Count for State Activity] 0 or >0
Max Duration for Stage (Days) Displays the maximum duration in which a request item has been in a particular stage. This metric is measured at the Stage level and provides the maximum duration of a stage across all the request items. Max(([Primary Duration] / 86400)){[Request Item From Stage (Source)]+} 0 or >0
Min Duration for Stage (Days) Displays the minimum duration in which a request item has been in a particular stage. This metric is measured at the Stage level and provides the minimum duration of a stage across all the request items. Min (([Primary Duration] / 86400)){[Request Item From Stage (Source)]+} 0 or >0
Max Duration for State (Days) Displays the maximum duration in which a request item has been in a particular state. This metric is measured at the State level and provides the maximum duration of a state across all the request items. Max(([Primary Duration] / 86400)){[Request Item From State (Source)]+} 0 or >0
Min Duration for State (Days) Displays the minimum duration in which a request item has been in a particular state. This metric is measured at the State level and provides the minimum duration of a state across all the request items. Min (([Primary Duration] / 86400)){[Request Item From State (Source)]+} 0 or >0
Stage Change Count {Request Item Number} Displays the number of stage changes that a request item has been through. Max([Avg Request Item Stage Change Count]){[Request Item Number]+} 0 or >0
Stage Duration (Days) Displays the total time taken by a request item in a particular stage. Sum([Primary Duration]) / 86400<[Request Item Activity Type Stage]> 0 or >0
State Change Count {Request Item Number} Displays the number of state changes that a request item has been through. Max([Avg Request Item State Change Count]){[Request Item Number]+} 0 or >0
State Duration (Days) Displays the total time taken by a request item in a particular state. Sum ([Primary Duration]) / 86400<[Request Item Activity Type State]> 0 or >0
Target Duration (Days) Displays the total time taken by a Request Item in a target stage Sum(([Target Duration] / 86400)){[Request Item From Stage (Source)]+} 0 or >0

 

© 2022 Digital.ai Inc. All rights reserved.