Time spent

The Time Spent dataset tracks the time spent on various work items within a project or portfolio. It offers valuable insights into resource allocation and the duration required to complete tasks, features, user stories, or epics, helping teams identify inefficiencies and enhance productivity. By providing a clear understanding of time management, this dataset enables teams to improve resource allocation, project timelines, and overall efficiency in agile development.

In analyzing the Time Spent dataset, you can leverage the assignee and reporter flags to gain insights into who records the time entries. For instance, when the assignee flag is set to true, it indicates that the person updating the time is also the assignee of the work item, which applies to both tasks and stories. Conversely, if the reporter flag is set to true, it signifies that the time entry was made by the person who initially reported the work item. In cases where both flags are false, it shows that the time was recorded by someone other than the assignee or reporter, helping track contributions from other team members. This functionality is crucial for accurate tracking and understanding of the involvement of various individuals in time management across different work items.

The following are the components of this dataset:

Attribute Name	Description
Assignee flag	Flag to indicate whether the person is one of the assignees to other portfolio items
Reporter flag	Flag of the reporter
Sys_source	Unique identifier for the source
Task	Unique identifier for the Task
Test	Unique identifier for the Test
Time spent date	The date on which time was logged for a work item.
Time spent updated by	The person who last modified the time logged for a work item.
Time spent updated datetime	The date and time on which time was logged for a work item.
Work item	Unique identifier for the work item
Work item planning level	Planning level of the work item

Metric Name	Description
Number of time spent by reporter	The amount of time spent on tasks and stories, segmented by the individual who reported them.
Number of time spent updates	The total number of time entries recorded for tasks and stories.
Number of time spent updates by assignee	The number of times the time spent record was updated by the assignee of the task or story.
Time spent hours	The total number of hours spent on tasks or activities within a project.
Time spent by assignee hours	The total number of hours each assignee has spent on tasks or activities.
Time spent by child tasks hours	Total hours spent on individual child tasks within a project