Dataset: Commits from pull requests
Entity: Commit
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 (Commits) | Calculated |
Gitlab (Commits) | Calculated |
Bitbucket (Commits) | Calculated |
Azure DevOps (Commits) | 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 commit. Its primary role in reporting is to serve as the foundational key for accurate counting and, most importantly, for enabling precise drilldowns from high-level metrics to the specific commits they represent.
Enabling Accurate Drilldowns: This is the field's most critical function for analysis. When you create an aggregated widget - such as a line chart of "Commits per Week" - and you click a data point that represents "50 commits," the
ID (System)is what allows the system to accurately fetch and display the 50 individual commits that make up that total. It acts as the unique primary key for each record in the drilldown report, ensuring that the detailed view perfectly matches the aggregated metric you clicked on. While you typically wouldn't display theID (System)itself in the drilldown table, it's the invisible engine that guarantees the accuracy of theMessage,Author, andCreated Atfields you do see.