Skip to main content
Version: 24.3

Fact.Effort

Effort is a measure of the amount of time spent working on a feature or defect. In the core application, effort is accumulated in the Done field and is historically accurate1. Each row in the Fact.Effort table represents a single Effort entry in and is also historically accurate. Values in this table are additive, meaning that it does not accumulate over time. There are several existing reports that use this metric

Table Description

The following table describes the columns available in the Fact.Effort table.

Column NameDescriptionDatatypeSource
EffortKeyDatamart unique identifier for this entryint
AuditIdentifier for this entryint
DateKeyDate this entry was reported as Foreign Key relationshipintDim.Date
DateDate this entry was reporteddatetime
MemberKeyMember reporting effortintDim.Member
WorkitemKeyIdentifies the Workitem where effort was reportedint
ProjectKeyIdentifies the Project where effort was reportedintDim.Project
IterationKeyIdentifies the Iteration where effort was reportedintDim.Iteration
TeamKeyIdentifies the Team reporting effortintDim.Team
PrimaryWorkitemKeyIdentifies the Primary Workitem associated with this entryintDim.PrimaryWorkitem
SecondaryWorkitemKeyIdentifies the Task or Test associated with this entryintDim.SecondaryWorkitem
ThemeKeyIdentifies the Theme associated with this entryintDim.Theme
EpicKeyIdentifies the Epic associated with this entry at the time the Effort was enteredintDim.Epic
EffortEffort valuedecimal(16,2)
  1. The term "historically accurate" means that the attributes are correct at the time the Effort is recorded and do not change. For example, if effort is recorded against a Defect in project X and that Defect is moved to project Y, the Effort record does not reflect the move. If you need Effort based on current attributes values, consider using the Done column in Fact.PrimaryWorkitem, Fact.Task, Fact.Test, or Fact.Workitem
  2. Fact.Effort contains the same information as source table in VersionOne. Additionally, each Effort record in Fact.Effort is augmented with EpicKey by the ETL. EpicKey is the unique identifier for the Portfolio Item associated with Story, Defect, TestSet at the time the Effort was entered. Thus a Story, connected to Portfolio Item A when Effort is entered and then moved to Portfolio Item B, will contain Effort associated to both Portfolio Items in Fact.Effort.