Open topic with navigation

Incident Monthly Snapshot

Incident Monthly Snapshot iCube enables you to create ad hoc reports that help you analyze information related to Incident task on a monthly basis.

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 required 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 Incident Monthly Snapshot iCube :

If you want to find the Incidents Backlog associated with the Incident Monthly Snapshot, perform the following steps:

1. From the DASHBOARD DATA SETS panel,
   1. Double-click Assignment Group Manager attribute to add it to the grid.
   2. Double-click the Incidents Backlog 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 Incident Monthly Snapshot attributes:

Attribute Name	Description
Assigned To	Person primarily responsible for working on the Incident
Assigned To Manager	Manager of the person primarily responsible for working on the Incident
Assignment Group	Group or team of people primarily responsible for working on the Incident
Assignment Group Manager	Manager of the group/team of the people primarily responsible for working on the Incident
Business Service	Business service impacted by the Incident
Calendar Month	Gregorian calendar month
Category	Name of the Incident category
Configuration Item	Configuration Item associated with the Incident
Department	Department associated with the Incident
Employee	Name of the employee associated with the Incident
Priority	Priority of the Incident
Reopened Flag	Flag that indicates if the Incident is reopened
State	Current state of the Incident

Metrics

Expand this link to view the Incident Monthly Snapshot metrics:

Metric Name	Description	Formula	Expected Values
Avg Incidents Age (Days)	Average age of all incidents	[Sum of Incident Age (Days) - Monthly] / [Opened Incidents Monthly Snapshot]	>0
Incidents Backlog	Total number of incidents in the Backlog	Count ([Opened Incidents Monthly Snapshot])	>0
Max of Incident Age (Days) - Monthly	Age of the oldest incident	Max (([Age Monthly Snapshot Fact] / 86400))	0 or >0
Min of Incident Age (Days) - Monthly	Age of the newest incident	Min (([Age Monthly Snapshot Fact] / 86400))	0 or >0
Reopened Incidents Backlog	Count of currently open incidents that were reopened	Count ([Opened Incidents Monthly Snapshot])<[Incident Reopened = Y (Monthly Snapshot)]>	>=0