Skip to main content

Task Base

The task base dataset is a comprehensive collection of data points detailing the various tasks within a project. Crucial for tracking progress, managing workloads, and ensuring timely task completion, this dataset supports Agile frameworks. It offers an overview of tasks that can be represented and managed in an Agile project, enabling teams to monitor task details, track progress, and facilitate effective communication and collaboration.

To analyze metrics at the portfolio item level, ensure the work item is linked appropriately. Tasks should be linked to their parent work items, which should be linked to portfolio items. This linkage is essential to see metrics at the portfolio item level.

The following are the components of this dataset:

Attribute NameDescription
Parent work itemParent work item of the task
Task category typeType of task
Task closed byPerson who closed the work item
Task closed onDate on which the task was closed
Task completed byPerson who changes the work item status to the completed category
Task completed onDate on which the task was changed to the completed category.
Task created byPerson who created the work item
Task inprogress flagFlag (Y/N) indicating whether the work item is currently in the “In Progress” status category.
Task iterationLast iteration of the task
Task last inprogress dateLast time the task was marked as in progress
Task last updated byPerson who recently updated the work item
Task last updated onDate on which the task was recently updated
Task nameName of the task
Task numberUnique identifier for the task
Task planning levelPlanning level of the task
Task stateState of the task
Task statusStatus of the task
Task teamTeam of the task
Task work start onDate on which the task was started
Sys_sourceUnique identifier for the source
Work item teamTeam that works on the work item
Metric NameDescription
Detail estimate (Days)The total estimate in days from child tasks.For example, the total estimate in days from all the child tasks. You can view it at the portfolio item level or at the story level.
Detail estimate (Hours)The total estimate in hours from child tasks.
Done (Days)The total time spent in days on child tasks.
Done (Hours)The total time spent in days on child tasks.
Number of tasks closedThe count of tasks that have reached a "Closed" state.
Number of tasks closed without detail estimateThe count of tasks that are closed without detail estimate.
Number of tasks closed without TodoThe count of tasks that are closed without a to do entry.
Number of tasks createdThe count of created tasks.
Number of tasks created without detail estimateThe count of created tasks without detail estimate.
Number of tasks created without TodoThe count of created tasks without a to do entry.
Task detail estimateThe estimated amount of time required to complete the task.
Task time spentAmount of time spent on the task
Task TodoThe remaining amount of work or tasks is yet to be completed.
Todo (Days)The remaining work is to be done in days
Todo (Hours)The remaining work is to be done in hours