Dataset: Reviews from pull requests
Entity: Pull Request Review
Field ID: updated_at
Type: Datetime
Description: The datetime at which the review was last updated.
Source: App
From: |
|
Github (Reviews) |
|
Gitlab (MRs) |
|
Bitbucket (PRs) |
|
Azure DevOps (PR Threads) |
|
Jira | N/A |
ClickUp | N/A |
Trello | N/A |
Reporting Use Cases
The Updated At field from the Reviews dataset is a specialized timestamp that records the last time a review was modified after its initial submission, for instance, if it was edited or dismissed. Its primary use is for auditing and tracking changes to the review record itself.
Filtering for Changed Reviews: You can use this field to find reviews that were altered after they were first submitted.
To create a report of all edited reviews, you can use a formula where
Updated At > Submitted At. This is useful for auditing purposes, especially to see if feedback was changed or clarified.To find reviews that were recently dismissed or changed, you can use a filter like
Updated At in the previous 7 days.
Analyzing Time to Update: You can measure the time between a review's submission and its subsequent modification to understand how and when feedback evolves.
A custom formula like
(updated_at - submitted_at) / DAY()can calculate the "time to revision." A short duration might indicate a quick correction, while a long duration could be the result of a review being dismissed much later in the pull request's lifecycle.
Distinguishing from Core Timestamps: For all standard reporting on review cycle times and throughput, the
Created AtandSubmitted Atfields should be used. TheUpdated Atfield is reserved for the specific use case of tracking modifications to a review after it has already been completed.
