Fact Project Summary
Overview
The Fact.ProjectSummary table contain roll-up metrics about Projects defined in your 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 |
| ProjectStatustKey | Data Mart identifier for the Project Status | int | Dim.ProjectStatus |
| TotalEstimate | Roll-up of the Estimate on all Primary Workitems in the Project regardless of state | 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 | real | |
| 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 | |
| DefectCountInProgress | 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 in the Project regardless of state | real | |
| OpenDetailEstimate | Roll-up of the Open Detail Estimate on all Primary Workitems in the Project | real | |
| ClosedDetailEstimate | Roll-up of the Closed Detail Estimate on all Primary Workitems 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 |