Open topic with navigation

Problem State Change

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

If you want to determine the current state of a problem based on its opened date and the total time period that the problem persisted in a state, perform the following steps:

1. From the DASHBOARD DATA SETS panel,
   1. Double-click Current State attribute to add it to the grid.
   2. Double-click Problem attribute to add it to the grid.
   3. Double-click Opened Date attribute to add it to the grid
   4. 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.

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 Problem State Change iCube attributes:

Attribute Name	Description
Actual End Date	Date on which the work of the problem ended
Actual Start Date	Date on which the work of the problem started
Assigned To	Person primarily responsible for working on the problem
Assigned To Manager	Manager of the assignee
Assignment Group	Group or team of the person primarily responsible for working on the problem
Assignment Group Manager	Manager of the Assignment group responsible for working on the problem
Change Number	Change request that caused the Problem
Closed Date	Date when the problem was closed
Configuration Item	Configuration item that affected by the problem
Current State	Indicates the current state of the problem
Due Date	Date by when the Problem is scheduled for completion.
Impact	Indicates the level of impact of the problem to the Business service or application
Known Error Flag	Flag that indicates if the problem is a known error
Next State	Next status of the problem relative to the specific transition
Opened Date	Date when the Problem is opened
Priority	Priority of the Problem
Problem Number	Unique identifier of the Problem
Short Description	Short description given to the Problem at the Source System
State	Indicates the state of the Problem
State Change Count	Count of the number of times the status of a given Problem has changed
State Change Date	Date on which the Problem changed status
State Sequence Number	Sequence Number assigned to every status
Urgency	Indicates the urgency to close the Problem

Metrics

Expand this link to view the Problem State Change iCube metricss:

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