Problem Task iCube enables you to create ad hoc reports for analysis. You can use this report to analyze problem task details spanning the life cycle of a Problem Task.
The iCube fetches Problem Tasks that were opened or closed in the last 12 months (including current month) along with Problem Task records that were created beyond 12 months but are currently in the Open state. However, the metrics in the iCube are calculated based on the relevant conditions and dates.
You can use the following attributes and metrics provided as part of the iCube to create your own reports:
Attribute Name | Description |
---|---|
Application | Application that is impacted by the Problem Task |
Approval | Approval Status for the Problem Task (Approved, Not Yet Requested) |
Assigned To | Person primarily responsible for working on the Problem Task |
Assigned To Manager | Manager of the Assigned To person |
Assignment Group | Group/team of the person who is working on the Problem Task |
Assignment Group Manager | Manager of the Assignment Group |
Backlog Flag | Flag to indicate if the Problem Task is in a backlog |
Business Service | Business service that is impacted by the Problem Task |
Calendar Date | Gregorian Calendar Date |
Closed By | Name of the person who closed the Problem Task |
Closed Date | Date on which the Problem Task was closed |
Configuration Item | Configuration item associated with the Problem Task |
Contact Type | Type of communication used to report the Problem Task (for example, phone, email, and so on) |
Date | Gregorian calendar date |
Dormant Flag | Flag to indicate if the Problem Task is dormant |
Due Date | Date by when the Problem Task is scheduled for completion. |
Employee | Person who has opened the Problem Task |
Impact | Indicates the severity of the Problem Task |
Location | Location of the affected caller or service |
Met All SLAs Flag | Flag to indicate if the Problem Task has met all SLAs |
Opened By | Name of the person who opened the Problem Task |
Opened Date | Date on which the Problem Task was opened |
Overdue Flag | Flag that indicates if the Problem Task is overdue |
Priority | Priority level for resolving the Problem Task |
Problem | Problem represents a cause or potential cause of one or more Incidents |
Problem Assignment Group | Group to which the parent Problem has been assigned |
Problem Closed Date | Date on which the parent problem was closed |
Problem Number | Unique identification number for the parent problem |
Problem Opened Date | Date on which the parent problem was opened |
Problem Priority | Priority level of the parent Problem |
Problem State | State of the parent Problem |
Problem Task | Smallest unit of work that you should perform to complete a Problem |
Problem Task Number | Unique identifier of the Problem Task |
Problem Task Priority (Standardized) | Internal standardized values representing the source values of Problem Task Priority |
Problem Task State (Standardized) | Internal standardized values representing the source values of Problem Task State |
Short Description | Short description given to the Problem Task at the source system |
State | State of the Problem Task |
Urgency | Indicates the urgency level to solve the Problem Task |
Metric Name | Description | Formula | Expected Values |
---|---|---|---|
Age of Parent at Problem Task Closure (Days) | Age of the parent Problem, when the corresponding child Problem Task was closed. | Sum (([Parent Age at Task Closure] / 86400)){~} | 0 or >0 |
Age of Parent at Problem Task Open (Days) | Age of the parent Problem, when the corresponding child Problem Task was opened. | Sum(([Parent Age at Task Open] / 86400)){~} | 0 or >0 |
Avg Update Count | Number of times a problem task has been updated, on an average. This metric is calculated as the number of updated problem tasks divided by the number of opened problem tasks. | [Problem Task Update Count] / [Opened Problem Tasks] | 0 or >0 |
Avg Age (Days) | Average number of days that the currently open Problem Tasks have been open | [Problem Task Age (Days)] / [Opened Problem Tasks] | 0 or >0 |
Avg Approval Duration (Days) | Time taken, on an average, for the problem task to be approved. This metric is calculated as the sum of problem task approval duration divided by the number of approved problem tasks. | [Problem Task Approval Duration (Days)] / [Approved Problem Tasks] | 0 or >0 |
Avg Days since Last Update | Average number of days since a Problem Task was last updated. | [Problem Task Days since Last Update] / [Problem Task Backlog] | >0 |
Avg Overdue Duration (Days) | Average time taken by problem tasks beyond the specified due date. This metric is calculated as the sum of time taken by overdue problem tasks divided by the number of overdue problem tasks. | [Problem Task Overdue Duration (Days)] / [Overdue Problem Tasks] | > =0 |
Avg Reassignment Count | Count of the number of times a problem task has been reassigned between assignment groups, on an average. This metric is calculated as the number of reassigned problem tasks divided by the number of opened problem tasks. | [Problem Task Reassignment Count] / [Opened Problem Tasks] | >=0 |
Avg Time Worked (Days) | Average of the total time spent on the problem tasks. This metric is calculated as the total time spent on the problem tasks divided by the number of closed problem tasks. | [Problem Task Time Worked (Days)] / [Closed Problem Tasks] | 0 or >0 |
Business Duration (Days) | Displays the total business time taken for a specific problem task to move from open to close. | Sum(([Business Duration] / 86400)){~} | 0 or >0 |
Closed Problem Tasks | Total number of Problem Tasks that have been closed. | Count([Closed Problem Tasks]){~} | >=0 |
Days Since Last Update | For Open Tasks, the number of days between today and last updated date. | Sum(([Dormancy Age] / 86400))<[Problem Task Backlog]> | >0 |
Days until Problem Task due date PV 1 {None} | Threshold metric that represents days until Problem Task Due Date PV1 value, which can be used to specify a threshold range for Problem Tasks that are about to breach their due date. By default, the threshold value is set to 0. | Max([Days until Problem Task due date PV 1]) | 0 |
Days until Problem Task due date PV 2 {None} | Threshold metric that represents days until Problem Task Due Date PV2 value, which can be used to specify a threshold range for Problem Tasks that are about to breach their due date. By default, the threshold value is set to 1. | Max([Days until Problem Task due date PV 2]) | 1 |
Days until Problem Task due date PV 3 {None} | Threshold metric that represents days until Problem Task Due Date PV3 value, which can be used to specify a threshold range for Problem Tasks that are about to breach their due date. By default, the threshold value is set to 3. | Max([Days until Problem Task due date PV 3]) | 3 |
Days until Problem Task due date PV 4 {None} | Threshold metric that represents days until Problem Task Due Date PV4 value, which can be used to specify a threshold range for Problem Tasks that are about to breach their due date. By default, the threshold value is set to 5. | Max([Days until Problem Task due date PV 4]) | 5 |
Days Until Problem Task Due Date | Total number of days remaining until the Problem Task reaches its due date. | Sum(([Time Until Problem Task Due Date] / 86400.0)) | >=0 |
Mean Open to Close Duration (Days) | Number of days taken for a Problem Task to move from 'Open' state to 'Close' state as compared to all closed Problem Tasks | [Problem Task Open To Close Duration (Days)] / [Closed Problem Tasks] | >0, Closer to 0 is ideal |
Open to Close Duration (Days) | Number of days taken for a Problem Task to move from 'Open' state to 'Close' state. | Sum(([Open To Close Duration] / 86400)){~+} | 0 or >0 |
Opened Problem Tasks | Count of the total number of Problem Tasks that have been opened so far. | Count([Opened Problem Tasks]) | >=0 |
Overdue Problem Tasks | Number of Problem Tasks which are overdue. | Count([Opened Problem Tasks])<[Problem Task Overdue]> | >=0 |
Problem Task Backlog | Displays the total number of problem tasks that are pending resolution as of a specific point in time, such as the end of the working day. | Count([Opened Problem Tasks])<[Problem Task Backlog]> | >=0 |
Reassignment Count | Count of the number of times a problem task has been reassigned between assignment groups. | Sum([Problem Task Reassignment Count]) | >=0 |
Update Count | Total number of times a problem task was updated. | Sum([Problem Task Update Count]) | >=0 |
© 2022 Digital.ai Inc. All rights reserved.