Fact.Workitem
This topic explains how to use the Fact workitem table in Agility.
Overview
The Fact.Workitem table contain metrics available on any Digital.ai Agility workitem; this includes primary and secondary workitems. Each row in the table represents a single workitem on a given day. All metrics in the table are semi-additive, meaning that are cumulative only for a given day.
The following metrics are available from this table
- Estimate
- Detail Estimate
- ToDo
- Done
- Supported Custom Fields defined on Primary and Secondary Workitems
Estimate
- The Estimate attribute on a PrimaryWorkitems
- Agility Reports using this metric
Detail Estimate
- The Detail Estimate attribute on all workitems
- Agility Reports using this metric
ToDo
- The ToDo attribute on all workitems.
- Agility Reports using this metric
Done
- The Done attribute on all workitems. This value represents the amount of Effort recorded against the workitem, regardless of of other attributes. The value is correct, but not always historically accurate. For more information, see the notes on Fact.Effort.
- Agility Reports using this metric
Table Description
The following table describes the columns available in the default table.
| Column Name | Description | Datatype | Foreign Key To |
| DateKey | Date of this measure | int | Dim.Date |
| WorkitemKey | Data Mart identifier for the PrimaryWorkitemKey or SecondaryWorkitemKey | int | |
| AssetTypeKey | Data Mart identifier for the type of workitem | int | Dim.AssetType |
| PrimaryWorkitemKey | Data Mart identifier for the Story or Defect | int | Dim.PrimaryWorkitem |
| SplitFromKey | Data Mart identifier for the Primary Workitem this Workitem was split from | int | Dim.PrimaryWorkitem |
| ProjectKey | Data Mart identifier for the Project containing this workitem | int | Dim.Project |
| IterationKey | Data Mart identifier for the Iteration containing this workitem | int | Dim.Iteration |
| ThemeKey | Data Mart identifier for the Theme containing this workitem | int | Dim.Theme |
| TeamKey | Data Mart identifier for the Team assigned to this workitem | int | Dim.Team |
| CustomerKey | Data Mart identifier for the Member acting as Customer when the workitem is a Story | int | Dim.Member |
| EpicKey | Data Mart identifier for the Epic, when this workitem is a Story that is part of an Epic | int | Dim.Epic |
| WorkitemSourceKey | Data Mart identifier for Source of this workitem | int | Dim.WorkitemSource |
| WorkitemPriorityKey | Data Mart identifier for the Priority of this workitem | int | Dim.WorkitemPriority |
| WorkitemStatusKey | Data Mart identifier for the Status of this workitem | int | Dim.WorkitemStatus |
| StoryRiskKey | Data Mart identifier for Risk when the workitem is a Story | int | Dim.StoryRisk |
| StoryTypeKey | Data Mart identifier for Type when the workitem is a Story | int | Dim.StoryType |
| DefectTypeKey | Data Mart identifier for Type when the workitem is a Defect | int | Dim.DefectType |
| DefectResolutionKey | Data Mart identifier for the Defect Resolution | int | Dim.DefectResolution |
| VerifiedByKey | Data Mart identifier for the Member that verified the Defect | int | Dim.Member |
| RegressionSuiteKey | Data Mart identifier for the Regression Suite | int | Dim.RegressionSuite |
| EnvironmentKey | Data Mart identifier for the Environment | int | Dim.Environment |
| RegressionPlanKey | Data Mart identifier for the Regression Plan | int | Dim.RegressionPlan |
| PrimaryAssetStateKey | Data Mart identifier for the asset state of the Story or Defect | int | Dim.AssetState |
| ClassOfService | Data Mart identifier for the Class of Service | int | Dim.ClassOfService |
| SecondaryWorkitemKey | Data Mart identifier when the workitem is a Task or Test | int | Dim.SecondaryWorkitem |
| TaskStatusKey | Data Mart identifier for the Task Status | int | Dim.TaskStatus |
| TaskTypeKey | Data Mart identifier for the Task Type | int | Dim.TaskType |
| TaskSourceKey | Data Mart identifier for the Task Source | int | Dim.TaskSource |
| SecondaryAssetStateKey | Data Mart identifier for the asset state of the Task or Test | int | Dim.AssetState |
| TestTypeKey | Data Mart identifier for the Test Type | int | Dim.TestType |
| TestStatusKey | Data Mart identifier for the Test Status | int | Dim.TestStatus |
| RegressionTestKey | Data Mart identifier for the Regression Test | int | Dim.RegressionTest |
| Estimate | Estimate Measure when the workitem is a Story or Defect | real | |
| DetailEstimate | Detail Estimate measure | real | |
| ToDo | ToDo measure | real | |
| Done | Effort measure | real |