Skip to main content
System StatusContact Support
VersionOne Community

Fact.EpicDaysIn

This feature is available in Enterprise and Ultimate editions.

The Fact.EpicDaysIn table contain information about how many days an Epic was in a given status value. Each row in the table represents a single Epic in a single status value.  The DateKey is always set the the maximum date value from Fact.Epic. It is important to note that oscillation between status values is not reflected in this table. Therefore, the "DaysInStatus" value may be greater than the value determined when you subtract FirstDateInStatus from LastDateInStatus.

Table Description

The following table describes the columns available in the default table.

Column Name Description Datatype Foreign Key To
DateKey Maximum Date in Fact.Epic int Dim.Date
EpicKey Data Mart identifier for the Epic int Dim.Epic
EpicStatusKey Data Mart identifier for the Epic Status value int Dim.EpicStatus
DaysInStatus The number of Days that this Epic has been in this status value int  
FirstDateInStatus   The First Date this Epic was seen in this Status Value datetime  
LastDateInStatus The Last Date this Epic was seen in this Status Value datetime  
  • Was this article helpful?