Fact.Epic
This feature is available in Enterprise and Ultimate editions.
Overview
The Fact.Epic table contain metrics available on the Epics defined in your VersionOne 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 on the Estimate value on all child workitems in the Not Started Reporting Category ; include those on child Epics | real | |
| InProgressEstimate | Roll-up on the Estimate value on all child workitems in the In Progress Reporting Category ; include 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 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 | To total amount of Detail Estimate on all child workitems; including those in child Epics | real | |
| TotalToDo | To total amount of ToDo on all child workitems; including those in child Epics | real |