Fact.PrimaryWorkitemDaysIn

The Fact.PrimaryWorkitemDaysIn table contain information about how many days a Story, Defect, or TestSet spent in a given Status value. Each row in the table represents a single Story, Defect, or TestSet was in a given status value. The DateKey is always set the the maximum date value from Fact.PrimaryWorkitem.
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.