Skip to main content
System StatusContact Support
VersionOne Community

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  

 

  • Was this article helpful?