Fact.Epic
Overview
The Fact.Epic table contain metrics available on the Epics defined in your instance. Each row in the table represents a single Epic 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
- Swag
- Value
- Risk
- Total Estimate
- Not Started Estimate
- In Progress Estimate
- Open Estimate
- Closed Estimate
- Workitem Count
- Not Started Workitem Count
- In Progress Workitem Count
- Open Workitem Count
- Closed Workitem Count
- UnEstimated Workitem Count
- Total Effort
- Total Detail Estimate
- Total ToDo
- Supported Custom Fields defined on Epics
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 |
| EpicKey | Data Mart identifier for the Epic | int | Dim.Epic |
| EpicAssetState | Data Mart identifier for the Asset State (Active or Closed) of this Epic | int | Dim.AssetState |
| ProjectKey | Data Mart identifier for the Project containing this Epic | int | Dim.Project |
| EpicStatusKey | Data Mart identifier for the Status of this Epic | int | Dim.EpicStatus |
| EpicPriorityKey | Data Mart identifier for the Priority of this Epic | int | Dim.EpicPriority |
| EpicTypeKey | Data Mart identifier for Type of this Epic | int | Dim.EpicType |
| EpicSourceKey | Data Mart identifier for Epic Source value | int | Dim.WorkitemSource |
| EpicTeamKey | Data Mart identifier for the Team value | int | Dim.Team |
| Swag | Swag attribute value | real | |
| Value | Value attribute value | real | |
| Risk | Risk attribute value | real | |
| TotalEstimate | Roll-up Estimate value for all child workitems; including those on child epics | real | |
| NotStartedEstimate | Roll-up Estimate value on all child workitems in the Not Started Reporting Category; including those on child Epics | real | |
| InProgressEstimate | Roll-up Estimate value on all child workitems in the In Progress Reporting Category; including those on child Epics | real | |
| OpenEstimate | Roll-up Estimate value for child workitems in the Not Started or In Progress Reporting Category; including those on child epics | real | |
| ClosedEstimate | Roll-up Estimate value for child workitems in the Complete Reporting Category; including those on child epics | real | |
| TotalWorkitemCount | The total number of child workitems; include those on child Epics | real | |
| NotStartedWorkitemCount | Total Number of child workitems in the Not Started Reporting Category; include those on child Epics | real | |
| InProgressWorkitemCount | Total Number of child workitems in the In Progress Reporting Category; include those on child Epics | real | |
| OpenWorkitemCount | The total number of child workitems in the Not Started and In Progress Reporting Category; include those on child Epics | real | |
| ClosedWorkitemCount | The total number of child workitems in the Completed Reporting Category; include those on child Epics | real | |
| UnEstimatedWorkitemCount | The total number of child workitems, include those on child Epics, that do not have an Estimate value | real | |
| TotalDone | The total amount of Effort reported against child workitems; include those on child Epics | real | |
| TotalDetailEstimate | The total amount of Detail Estimate on all child workitems; including those in child Epics | real | |
| TotalToDo | The total amount of ToDo on all child workitems; including those in child Epics | real |