Story
The Story dataset provides a comprehensive view of stories within Agile projects, enabling teams to track and manage their lifecycle, status, and performance. It consolidates data related to creation, updates, completion, and closure, offering insights into timelines, effort estimation, progress, and key metrics like lead time, cycle time, and effort spent. Designed to support Agile teams, Scrum Masters, and Product Owners, it facilitates project tracking, performance monitoring, resource allocation, iteration planning, and backlog management. With timestamps for critical events and details about ownership, priority, and planning levels, this dataset aids in optimizing workflows, identifying trends, improving delivery efficiency, and aligning Agile execution with business goals.
The data is filtered to include only stories with snapshot dates within the specified timeframe to ensure freshness and relevance.
The following are the components of this dataset:
| Attribute Name | Description |
|---|---|
| Last refresh date | Last ETL refresh date |
| Story | Unique identifier of the story |
| Story backlog group | The backlog group to which the story belongs |
| Story category type | Category type from which the story originated |
| Story class of service | Class of Service value associated with the story |
| Story closed by | Person who completed the story |
| Story closed datetime | The date when the story was closed |
| Story completed by | Person who completed the story |
| Story completed datetime | Date and time when the story was completed |
| Story created by | Person who created the story |
| Story created datetime | Date and time when the story was created |
| Story in progress datetime | Earliest date when the story was marked as in progress |
| Story iteration | The iteration to which the story is linked |
| Story last iteration end datetime | Planned end date and time of the last iteration linked to the story |
| Story last iteration start datetime | Actual start date and time of the last iteration linked to the story |
| Story last update datetime | Date and time when the story was last updated |
| Story last updated by | Person who last updated the story |
| Story linked to portfolio flag | Flag to indicate if the story is linked to a portfolio item |
| Story not started flag | Flag to indicate whether the story has not started |
| Story original completed by | Person who originally completed the story |
| Story original completed datetime | Date and time when the story was originally completed |
| Story planning level | The planning level to which the story belongs |
| Story points | Story points assigned to the story |
| Story portfolio item | Portfolio item to which the story is linked |
| Story priority | Priority of the story |
| Story reopened by | The user who reopened the story |
| Story reopened date | Date and time when the story was reopened |
| Story source URL | Story source system URL |
| Story split from | Identifier for the parent story from which the current story was split |
| Story state | Current state of the story |
| Story status | Status of the story |
| Story status category | Current state category of the story |
| Story summary | The description or summary of the story |
| Story team | Team that is linked to the story |
| Story type | The type of work item represented by the story |
| Sys_source | Source system identifier |
| Metric Name | Description | Formula |
|---|---|---|
| Story age since creation in days | Age since the story was created in days | ((Closed datetime or Data Freshness date) - Created datetime) / 86400 |
| Story cycle time in days | Duration between when the story started and when it was closed | (Completed datetime – Work start datetime) / 86400 |
| Story detail estimate in days | Detail estimate of the time required to complete the story | Detail estimate hours / 8 |
| Story duration created to in progress | Time duration between story creation and completion | ((Work start datetime or Data Freshness date) - Created datetime) |
| Story lead time in days | Duration between the creation of the story and its completion | (Completed datetime – Created datetime) / 86400 |
| Story time spent in days | Total amount of time spent on the story | Time spent/ 8 |
| Story to-do hours in days | Total amount of time spent on to-do activities for the story | To-do hours/8 |