Dataset: Reviews from pull requests
Entity: Pull Request Review
Field ID: _system_id
Type: Text
Description: The universal ID assigned to the record to uniquely identify it across all application records.
Source: Calculated
From: |
|
Github (PRs) | Calculated |
Gitlab (PRs) | Calculated |
Bitbucket (PRs) | Calculated |
Azure DevOps (PR Threads) | Calculated |
Jira | N/A |
ClickUp | N/A |
Trello | N/A |
Reporting Use Cases
The ID (System) field is the unique identifier assigned by Keypup to every individual review. Its most critical role in reporting is to serve as the foundation for accurate counting and to enable precise drilldowns from high-level metrics to the individual reviews they represent.
Accurate Counting of Reviews: The primary use of this field is to provide a reliable basis for any metric that counts review events.
Enabling Accurate Drilldowns: This is an essential function for analysis. When you create a widget that aggregates reviews, such as a chart of "Reviews per State," and you click on a data point representing "15 APPROVED reviews," the
ID (System)is what allows the system to accurately fetch and display the 15 specific review records that make up that total. It acts as the unique key for each record in the drilldown, guaranteeing that the detailed list of reviews you see is a perfect, 1-to-1 match of the aggregated metric you are investigating.