Skip to main content
System StatusContact Support
VersionOne Community

Fact.ProjectSummary

This feature is available in Enterprise and Ultimate editions.

Overview

The Fact.ProjectSummary table contain roll-up metrics about Projects defined in your VersionOne instance. Each row in the table represents a single Project 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

  • Total Estimate
  • Not Started Estimate
  • In Progress Estimate
  • Open Estimate
  • Closed Estimate
  • Total Detail Estimate
  • Open Detail Estimate
  • Closed Detail Estimate
  • Total Remaining ToDo
  • Total Effort (Done)
  • Count of all Primary Workitems (Story, Defect, TestSet)
  • Count of Not Started Primary Workitems
  • Count of In Progress Primary Workitems
  • Count of Open Primary Workitems
  • Count of Closed Primary Workitems
  • Count of Stories
  • Count of Not Started Stories
  • Count of In Progress Stories
  • Count of Open Stories
  • Count of Closed Stories
  • Count of Defects
  • Count of Not Started Defects
  • Count in In Progress Defects
  • Count of Open Defects
  • Count of Closed Defects
  • Count of TestSets
  • Count of Not Started Test Count
  • Count of In Progress Test Count
  • Count of Open TestSets
  • Count of Closed TestSets
  • Count of Primary Workitem without an Estimate
  • Count of all Epics
  • Count of Not Started Epics
  • Count of In Progress Epics
  • Count of all Open Epic
  • Count of all Closed Epic
  • Count of all Issues
  • Count of Open Issues
  • Count of Closed Issues
  • Count of Requests
  • Count of Open Requests
  • Count of Closed Requests

 

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
ProjectKey Data Mart identifier for this Project int Dim.Project
AssetStateKey  Data Mart identifier for the Project State (Open/Closed) int  Dim.AssetState
ProjecStatustKey Data Mart identifier for the Project Status int Dim.ProjectStatus
TotalEstimate Roll-up of the Estimate on all Primary Workitems (Story/Defect/TestSet) in the Project regardless of state (Open/Closed) real  
NotStartedEstimate Roll-up of the Estimate on all Primary Workitems in the Project that are in the Not Started Reporting Category real  
InProgressEstimate Roll-up of the Estimate on all Primary Workitems in the Project that are in the In Progress Reporting Category    
OpenEstimate Roll-up of the Estimate on all Primary Workitems in the Project that are in the Not Started or In Progress Reporting Category. real  
ClosedEstimate Roll-up of the Estimate on all Primary Workitems in the Project in the Complete Reporting Category. real  
WorkitemCount Total Number of Primary Workitems in the Project regardless of status or state. real  
NotStartedCount Total Number of Primary Workitems in the Project in the Not Started Reporting Category real  
InProgressCount Total Number of Primary Workitems in the Project in the In Progress Reporting Category real  
OpenWorkitemCount Total Number of Primary Workitems in the Project in the Not Started or In Progress Reporting Category real  
ClosedWorkitemCount Total Number of Primary Workitems in the Project in the Complete Reporting Category real  
StoryCount Total Number of Stories in the Project regardless of status or state.     real  
StoryCountNotStarted Total Number of Stories in the Project in the Not Started Reporting Category real  
StoryCountInProgress Total Number of Stories in the Project in the In Progress Reporting Category real  
OpenStoryCount Total Number of Stories in the Project in the Not Started or In Progress Reporting Category real  
ClosedStoryCount Total Number of Stories in the Project in the Complete Reporting Category real  
DefectCount Total Number of Defects in the Project regardless of status or state real  
DefectCountNotStarted Total Number of Defects in the Project in the Not Started Reporting Category real  
DefecCountInProgress Total Number of Defects in the Project in the In Progress Reporting Category real  
OpenDefectCount  Total Number of Defects in the Project in the Not Started or In Progress Reporting Category real  
ClosedDefectCount Total Number of Defects in the Project in the Complete Reporting Category real  
TestSetCount Total Number of TestSets in the Project regardless of status or state. real  
TestSetCountNotStarted Total Number of TestSets in the Project in the Not Started Reporting Category real  
TestSetCountInProgress Total Number of TestSets in the Project in the In Progress Reporting Category real  
OpenTestSetCount Total Number of TestSets in the Project in the Not Started or In Progress Reporting Category real  
ClosedTestSetCount Total Number of TestSets in the Project in the Complete Reporting Category real  
UnestimatedWorkitemCount Total Number of Primary Workitem in the Project that do not have an Estimate value, regardless of status or state.  real  
ToDo Roll-up of ToDo on all Primary Workitems in the Project regardless of state. real  
Done  Roll-up of the Effort on all Primary Workitems in the Project. real  
TotalDetailEstimate Roll-up of the Detail Estimate on all Primary Workitems (Story/Defect/TestSet) in the Project regardless of state (Open/Closed) real  
OpenDetailEstimate Roll-up of the Open Detail Estimate on all Primary Workitems (Story/Defect/TestSet) in the Project real  
ClosedDetailEstimate Roll-up of the Closed Detail Estimate on all Primary Workitems (Story/Defect/TestSet) in the Project real  
EpicCount Total Number of Epics in the Project regardless of status or state. real  
EpicContNotStarted Total Number of Epics in the Project in the Not Started Reporting Category real  
EpicCountInProgress Total Number of Epics in the Project in the In Progress Reporting Category real  
EpicCountOpen  Total Number of Epics in the Project in the Not Started or In Progress Reporting Category real  
EpicCountClosed  Total Number of Epics in the Project in the Completed Reporting Category real  
IssueCount  Total Number of Issues in the Project regardless of state. real  
IssueCountOpen   Total Number of Open Issues in the Project. real  
IssueCountClosed Total Number of Closed Issues in the Project.  real  
RequestCount Total Number of Request in the Project regardless of state. real  
RequestCountOpen Total Number of Open Request in the Project.   real  
RequestCountClosed  Total Number of Closed Request in the Project. real  
TergetSwag The Target Swag value for this Project real  
TargetEstimate The Target Estimate value for this Project real  

 

  • Was this article helpful?