Open topic with navigation

Task

Task iCube enables you to create ad-hoc reports that help you analyze task information relevant to the corresponding task type, such as Incident, Change Request, Problem, Problem Task, Change Task, Request Task, Request Item, or Request.

This iCube fetches Tasks that were opened or closed in the last 12 months (including current month) along with 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:

Attributes

Expand this link to view the Task iCube attributes:

Attribute Name	Description
Application	Name of the application
Approval	Approval status for the Task; Approved or Rejected
Assigned To	Person primarily responsible for working on the Task
Assigned To Manager	Manager of the person primarily responsible for working on the Task
Assignment Group	Group or team that is primarily responsible for working on the Task
Assignment Group Level 1	Level 1 group or team that is primarily responsible for working on the Task
Assignment Group Level 2	Level 2 group or team that is primarily responsible for working on the Task
Assignment Group Level 3	Level 3 group or team that is primarily responsible for working on the Task
Assignment Group Level 4	Level 4 group or team that is primarily responsible for working on the Task
Assignment Group Manager	Manager of the group or team that is primarily responsible for working on the Task
Backlog Flag	Flag to indicate if this Task is a backlog
Business Service	Business service associated with the Task
Calendar Date	Gregorian calendar date
Closed By	Person who closed the Task
Closed Date	Date when the Task is closed
Configuration Item	Configuration item associated with the Task
Contact Type	Medium through with Task was reported
Dormant Flag	Flag that indicates if this task is in a dormant state
Due Date	Date when the Task is scheduled for completion
Employee	Assignee who is responsible for carrying out the Task
Impact	Impact of the task
Met All SLAs Flag	Flag to indicate if the Tasks meets all SLAs
Opened By	Person who opened the Task
Opened Date	Date when the Task is opened
Overdue Flag	Flag that indicates if the Task is overdue
Parent Task	Parent Task associated with a Task
Parent Task Number	Number that is associated to the parent task
Priority	Displays the priority specified for the task
Short Description	Short description as captured in the source system
State	Current state of the Task
Task	Unique identifier of a task corresponding to task types, such as Incident, Problem, Change, and Request.
Task Date	Date on which the task was opened
Task Location	Location from where the Task is created
Task Number	Unique identifier of the Task
Task State (Standardized)	Internal standardized values representing the source values of Task State
Task Type (Standardized)	Internal standardized values representing the source values of Task Type
Type	Type of the Task, such as Incident, Change Request, Problem, Request Item, and so on.
Urgency	Indicates the urgency of the Task. For example, Critical, High, and Medium

Metrics

Expand this link to view the Task iCube metrics:

Metric Name	Description	Formula	Expected Values
Age of Parent At Task Closure (Days)	Displays the age of the parent task in days when the corresponding child task was closed.	Sum(([Parent Age at Task Closure] / 86400)){~}	0 or >0
Age of Parent At Task Open (Days)	Displays the age of the parent task in days when the corresponding child task was opened.	Sum(([Parent Age at Task Open] / 86400)){~}	0 or >0
Avg Age (Days)	Displays the average age of the task. This metric is calculated as the sum of task age divided by the number of opened tasks. Task age is the time taken, in days since the creation of the task.	([Sum Task Age (Days)] / [Opened Tasks])	0 or >0
Avg Approval Duration (Days)	Displays the average approval duration for the task. Approval duration is the time taken for the task to be approved. This metric is calculated as the sum of task approval duration divided by the number of approved tasks.	([Task Approval Duration (Days)] / [Approved Tasks])	0 or >0
Avg Overdue Duration (Days)	Average number of days since the Task has passed its due date as compared to all overdue tasks	[Task Overdue Duration (Days)] / [Overdue Tasks]	>=0
Avg Reassignment Count	Displays the average count of the tasks that have been reassigned between assignment groups. This metric is calculated as the number of reassigned tasks divided by the number of opened tasks.	([Task Reassignment Count] / [Opened Tasks])	>=0
Avg Update Count	Displays the average count since a task was last updated. This metric is calculated as the number of updated tasks divided by the number of opened tasks.	(([Task Update Count] / [Opened Tasks]))	>=0
Business Duration (Days)	Displays the total time taken from task open to closure.	Sum (([Business Duration] / 86400))	0 or >0
Closed Tasks	Displays the total number of tasks closed in a period of time.	Count ([Closed Tasks])	>=0
Mean Time to Close Duration (Days)	Displays the elapsed time between task creation and closure. The elapsed time is measured as the total time open. This metric is calculated as the sum of time duration taken to close tasks divided by the number of closed tasks.	(([Task Open To Close Duration (Days)] / [Closed Tasks]))	0 or >0
Open To Close Duration (Days)	Displays the number of days between the date a task was Opened and Closed. This metric is calculated as the number of days between Opened Date and Closed Date.	Sum (([Open To Close Duration] / 86400)){~+}	0 or >0
Opened Tasks	Displays the total number of tasks that are open.	Count ([Opened Tasks])	>=0
Overdue Tasks	Displays the total number of tasks that are overdue. This metric is calculated as the number of opened tasks with the Overdue flag set to Y.	Count ([Opened Tasks])<[Overdue = Y]>	>=0
Reassignment Count	Displays the sum of the number of tasks that have been reassigned between assignment groups.	Sum ([Task Reassignment Count])	>=0
Task Backlog	Displays the total number of tasks that are pending resolution as of a specific point in time, such as the end of the working day.	Count ([Opened Tasks])<[Backlog = Y]>	>0
Time Worked (Days)	Displays the total time spent on a task.	Sum (([Time Worked] / 86400))	0 or >0
Update Count	Displays the total number of times a task was updated.	Sum ([Task Update Count])	0 or >0