Skip to main content
Version: Early Access

Fact Workitem

Overview​

The Fact.Workitem table contain metrics available on any workitem; this includes primary and secondary workitems. Each row in the table represents a single workitem 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

  • Estimate
  • Detail Estimate
  • ToDo
  • Done
  • Supported Custom Fields defined on Primary and Secondary Workitems

Estimate​

  • The Estimate attribute on a PrimaryWorkitems
  • Reports using this metric

Detail Estimate​

  • The Detail Estimate attribute on all workitems
  • Reports using this metric

ToDo​

  • The ToDo attribute on all workitems.
  • Reports using this metric

Done​

  • The Done attribute on all workitems. This value represents the amount of Effort recorded against the workitem, regardless of of other attributes. The value is correct, but not always historically accurate. For more information, see the notes on Fact.Effort.
  • Reports using this metric

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 WorkitemKey Data Mart identifier for the PrimaryWorkitemKey or SecondaryWorkitemKey int
AssetTypeKey Data Mart identifier for the type of workitem int Dim.AssetType PrimaryWorkitemKey Data Mart identifier for the Story or Defect int Dim.PrimaryWorkitem SplitFromKey Data Mart identifier for the Primary Workitem this Workitem was split from int Dim.PrimaryWorkitem ProjectKey Data Mart identifier for the Project containing this workitem int Dim.Project IterationKey Data Mart identifier for the Iteration containing this workitem int Dim.Iteration ThemeKey Data Mart identifier for the Theme containing this workitem int Dim.Theme TeamKey Data Mart identifier for the Team assigned to this workitem int Dim.Team CustomerKey Data Mart identifier for the Member acting as Customer when the workitem is a Story int Dim.Member EpicKey Data Mart identifier for the Epic, when this workitem is a Story that is part of an Epic int Dim.Epic WorkitemSourceKey Data Mart identifier for Source of this workitem int Dim.WorkitemSource WorkitemPriorityKey Data Mart identifier for the Priority of this workitem int Dim.WorkitemPriority WorkitemStatusKey Data Mart identifier for the Status of this workitem int Dim.WorkitemStatus StoryRiskKey Data Mart identifier for Risk when the workitem is a Story int Dim.StoryRisk StoryTypeKey Data Mart identifier for Type when the workitem is a Story int Dim.StoryType DefectTypeKey Data Mart identifier for Type when the workitem is a Defect int Dim.DefectType DefectResolutionKey Data Mart identifier for the Defect Resolution int Dim.DefectResolution VerifiedByKey Data Mart identifier for the Member that verified the Defect int Dim.Member RegressionSuiteKey Data Mart identifier for the Regression Suite int Dim.RegressionSuite EnvironmentKey Data Mart identifier for the Environment int Dim.Environment RegressionPlanKey Data Mart identifier for the Regression Plan int Dim.RegressionPlan PrimaryAssetStateKey Data Mart identifier for the asset state of the Story or Defect int Dim.AssetState ClassOfService Data Mart identifier for the Class of Service int Dim.ClassOfService SecondaryWorkitemKey Data Mart identifier when the workitem is a Task or Test int Dim.SecondaryWorkitem TaskStatusKey Data Mart identifier for the Task Status int Dim.TaskStatus TaskTypeKey Data Mart identifier for the Task Type int Dim.TaskType TaskSourceKey Data Mart identifier for the Task Source int Dim.TaskSource SecondaryAssetStateKey Data Mart identifier for the asset state of the Task or Test int Dim.AssetState TestTypeKey Data Mart identifier for the Test Type int Dim.TestType TestStatusKey Data Mart identifier for the Test Status int Dim.TestStatus RegressionTestKey Data Mart identifier for the Regression Test int Dim.RegressionTest Estimate Estimate Measure when the workitem is a Story or Defect real
DetailEstimate Detail Estimate measure real
ToDo ToDo measure real
Done Effort measure real

m