Dataset: Commits from pull requests
Entity: Commit
Field ID: id
Type: Text
Description: The ID assigned to the record by the source application. Except on Azure DevOps, this is not the commit hash: use SHA1 to identify a commit.
Source: App
App Mapping
Github (Commits) |
|
Gitlab (Commits) | Calculated: commit SHA and merge request ID |
Bitbucket (Commits) | Calculated: SHA256 of the pull request ID and the commit hash |
Azure DevOps (Commits) |
|
Jira | N/A |
ClickUp | N/A |
Trello | N/A |
Reporting Use Cases
The ID (Source) field uniquely identifies a commit record. Its primary role in reporting is to enable meaningful drilldowns from aggregated metrics to the specific, individual commits that make up the total.
Enabling Accurate Drilldowns: This is the most critical use case for this field. When you view a high-level metric, such as a bar chart showing "Commits per Day," and you click on a bar representing "15 commits," you need a way to see exactly which 15 commits those are. The drilldown view that appears will be a list of those individual commits, and the
ID (Source)serves as the unique key for each record. AddSHA1to the list to see the hash of every commit, a direct, unambiguous reference that you can use to investigate the code in your Git tool.Context in List Reports: In any list-based report that displays individual commits (not just drilldowns), the
ID (Source)(often shortened for readability) should be included as a dimension. It serves as the primary unique identifier, giving context and allowing for easy cross-referencing with your source code repository.Direct Filtering: While less common for general reporting, you can also use this field to isolate a single commit record, for example one found in a drilldown. To find a commit by its hash, filter on
SHA1instead, with a filter likeSHA1 = "a1b2c3d4e5f6a7b8c9d0...".
