Catalog Metric Data
- Anastasia Baranouskaya
PERF utilizes data stored in various tables from Jira to generate a set of catalog metrics. The Catalog Metric dataset consists of tables with values of the catalog PERF metrics. By using the Catalog Metric dataset, users can leverage the catalog metric values to develop personalized metrics (Custom Metrics) and even recreate catalog metrics with modifications based on their preferences.
How to Use the Catalog Metric Dataset
The Catalog Metric dataset is available as a separate dataset, featuring a collection of metrics. Each unit of measure and metrics, which include and exclude subitems from the calculation, are presented as separate tables.
In the table below, you can find a list of available catalog metrics and the name of the table based on their unit of measure and other settings:
Please pay attention that the Velocity Committed vs. Completed metric is stored in separate tables for committed values and completed values.
Metric Name | Metric UoM and settings | PERF table name |
|---|---|---|
Backlog Health | Backlog Health by sprints in hours | BH_hours |
Backlog Healthby sprints in hours with sub-items | BH_hours_subitems | |
Backlog Health by sprints in items | BH_items | |
Backlog Health by sprints in items with sub-items | BH_item_subitems | |
Backlog Health by sprints in Story Points | BH_sp | |
Backlog Health by sprints in Story Points with sub-items | BH_sp_subitems | |
Commitment Rate | Commitment Rate by release in items | CR_releases_items |
Commitment Rate by release in items with sub-items | CR_releases_items_subitems | |
Commitment Rate by release in original hours | CR_releases_oh | |
Commitment Rate by release in original hours with sub-items | CR_releases_oh_subitems | |
Commitment Rate by release in remaining hours | CR_releases_rh | |
Commitment Rate by release in remaining hours with sub-items | CR_releases_rh_subitems | |
Commitment Rate by release in Story Points | CR_releases_sp | |
Commitment Rate by release in Story Points with sub-items | CR_releases_sp_subitems | |
Commitment Rate by sprint in items | CR_sprints_items | |
Commitment Rate by sprint in items with sub-items | CR_sprints_items_subitems | |
Commitment Rate by sprint in original hours | CR_sprints_oh | |
Commitment Rate by sprint in original hours with sub-items | CR_sprints_hours_subitems | |
Commitment Rate by sprint in remaining hours | CR_sprints_rh | |
Commitment Rate by sprint in remaining hours with sub-items | CR_sprints_rh_subitems | |
Commitment Rate by sprint in Story Points | CR_sprints_sp | |
Commitment Rate by sprint in Story Points with sub-items | CR_sprints_sp_subitems | |
Defect Containment by Month | Defect Containment by month | DC_month |
Open Bugs over Time (incl. by Priority) | Open bugs over time | OB_all |
Open bugs over time by priority | OB_priority | |
Ready for Development | Ready for Development in hours | RD_hours |
Ready for Development in hours with sub-items | RD_hours_subitems | |
Ready for Development in items | RD_items | |
Ready for Development in items with sub-items | RD_items_subitems | |
Ready for Development in Story Points | RD_sp | |
Ready for Development in Story Points with sub-items | RD_sp_subitems | |
Scrum cycle time | Scrum Cycle time in items | SCT_item |
Sprint Plan Change | Sprint Plan Change in hours | SPC_hours |
 | Sprint Plan Change in items | SPC_items |
 | Sprint Plan Change in Story Points | SPC_sp |
Sprint Scope Creep | Sprint Scope Creep actual hours | SSC_ah |
 | Sprint Scope Creep actual hours with su-items | SSC_ah_subitems |
 | Sprint Scope Creep hours | SSC_hours |
 | Sprint Scope Creep hours with sub-items | SSC_hours_suitems |
 | Sprint Scope Creep items | SSC_items |
 | Sprint Scope Creep items with sub-items | SSC_items_subitems |
 | Sprint Scope Creep in Story Points | SCC_sp |
 | Sprint Scope Creep in Story Points with sub-items | SCC_sp_subitems |
Velocity Committed vs. Completed | Committed by release in actual hours | Cmt_releases_ah |
Committed by release in actual hours with sub-items | Cmt_releases_ah_subitems | |
Committed by release in items | Cmt_releases_items | |
Committed by release in items with sub-items | Cmt_releases_items_subitems | |
Committed by release in original hours | Cmt_releases_oh | |
Committed by release in original hours with sub-items | Cmt_releases_oh_subitems | |
Committed by release in remaining hours | Cmt_releases_rh | |
Committed by release in remaining hours with sub-items | Cmt_releases_rh_subitems | |
Committed by release in Stroy Points | Cmt_releases_sp | |
Committed by release in Stroy Points with sub-items | Cmt_releases_sp_subitems | |
Committed by sprint in actual hours | Cmt_sprints_ah | |
Committed by sprint in actual hours with sub-items | Cmt_sprints_ah_subitems | |
Committed by sprint in items | Cmt_sprints_items | |
Committed by sprint in items with sub items | Cmt_sprints_items_subitems | |
Committed by sprint in original hours | Cmt_sprints_oh | |
Committed by sprint in original hours with sub-items | Cmt_sprints_oh_subitems | |
Committed by sprint in remaining hours | Cmt_sprints_rh | |
Committed by sprint in remaining hours with sub-items | Cmt_sprints_rh_subitems | |
Committed by sprint in Stroy Points | Cmt_sprints_sp | |
Committed by sprint in Stroy Points with sub-items | Cmt_sprints_sp_subitems | |
Completed by release in actual hours | Cmpl_releases_ah | |
Completed by release in actual hours with sub-items | Cmpl_releases_ah_subitems | |
Completed by release in items | Cmpl_releases_items | |
Completed by release in items with sub-items | Cmpl_releases_items_subitems | |
Completed by release in original hours | Cmpl_releases_oh | |
Completed by release in original hours with sub-items | Cmpl_releases_oh_subitems | |
Completed by release in remaining hours | Cmpl_releases_rh | |
Completed by release in remaining hours with sub-items | Cmpl_releases_rh_subitems | |
Completed by release in Stroy Points | Cmpl_releases_sp | |
Completed by release in Stroy Points with sub-items | Cmpl_releases_sp_subitems | |
Completed by sprint in actual hours | Cmpl_sprints_ah | |
Completed by sprint in actual hours with sub-items | Cmpl_sprints_ah_subitems | |
Completed by sprint in items | Cmpl_sprints_items | |
Completed by sprint in items with sub-items | Cmpl_sprints_items_subitems | |
Completed by sprint in original hours | Cmpl_sprints_oh | |
Completed by sprint in original hours with sub-items | Cmpl_sprints_oh_subitems | |
Completed by sprint in remaining hours | Cmpl_sprints_rh | |
Completed by sprint in remaining hours with sub-items | Cmpl_sprints_rh_subitems | |
Completed by sprint in Stroy Points | Cmpl_sprints_sp | |
Completed by sprint in Stroy Points with sub-items | Cmpl_sprints_sp_subitems |