Dataset: Issues & Pull Requests
Entity: Pull Requests
Field ID: mergeable
Type: Select list
Description: The mergeability state of the pull request. Possible values are:
MERGEABLEthe pull request can be safely mergedCONFLICTINGthe pull request conflicts with the base branchUNKNOWNthe mergeability state cannot be evaluated or is being evaluated
Source: App
Transformation logic: N/A
From: |
|
Github (PRs, Issues) |
|
Gitlab (PRs, Issues) |
|
Bitbucket (PRs, Issues) | Evaluated using the merge status of each file in diffstats.files:
|
Azure DevOps (PRs, Issues) |
|
JIRA (Issues) | N/A |
ClickUp (Issues) | N/A |
Trello (Issues) | N/A |
Reporting Use Cases
The Mergeable field is a vital, real-time indicator of a pull request's health, allowing you to proactively identify and manage integration blockers. Its primary use is for filtering and creating high-level KPIs to monitor the overall health of your development pipeline.
Filtering for Immediate Action: You can create actionable lists that help developers prioritize their work and keep the pipeline flowing.
Find Conflicting PRs: The most critical use case is to build a report of all open pull requests that need immediate attention by using a filter like
Mergeable = "CONFLICTING". This allows developers to resolve conflicts before the branch diverges too far from the base.Create a "Ready to Merge" Queue: You can identify pull requests that are fully ready for deployment by combining filters to ensure they meet all criteria:
Mergeable = "MERGEABLE" and Review State = "APPROVED" and Build Status = "SUCCESS".
Reporting on Pipeline Health: Using
Mergeableas a dimension gives you a high-level snapshot of the state of your open pull requests.A pie chart with
Mergeableas the dimension andCOUNT()as the metric can instantly show you the proportion of your open work that is healthy, blocked by conflicts, or in an unknown state.
Custom Formulas for Trend Analysis: You can track the health of your branching and integration strategy over time by creating targeted KPIs.
Conflict Rate: Monitor the percentage of open pull requests that are conflicting with a custom formula like
ROUND(COUNT_IF(mergeable == "CONFLICTING") / COUNT() * 100, 2). A rising trend in this metric can be an early warning sign that your feature branches are too long-lived or that your team needs to rebase more frequently.
