Dataset: Issues & Pull Requests

Entity: Pull Requests

Field ID: resolved_issue_first_created_at

Type: Datetime

Description: The earliest creation date among all resolved issues (via auto-closing keywords).

It can be used to calculate specific stages of the cycle time. E.g. the time elapsed between the creation date of an issue and the actual end of the development.

Source: Calculated

Transformation logic:

Definition of resolved issues:

A resolved issue is an issue that is referenced by a resolving pull request.

A resolving pull request is a pull request that:

This last condition ensures that release PRs (e.g. PR from master to staging then staging to production) do not get considered as resolving if they follow a proper implementation PR (e.g. from my-feature-branch to master), even though they contain references to issues through commits.

This condition replaces the rule from GitHub, GitLab, and Bitbucket that resolving pull requests must target the main branch. This condition is not practical for Keypup since the main branch can change over time. Using this definition would mean that any resolving PR preceding a change of the main branch would no longer be considered as resolving, which would impact historical reporting.

The Keypup definition also brings some flexibility in case of emergency releases. If you push an emergency fix referencing an issue to the main branch and then release this fix through release PRs, then the first release PR will be considered as a resolving PR (GitHub/GitLab/Bitbucket would simply ignore it). This information can then be used for incident reporting in Keypup.