Dataset: Commits from pull requests
Entity: Commit
Field ID: created_at
Type: Datetime
Description: The datetime at which the commit was created.
Source: App
From: |
|
Github (Commits) |
|
Gitlab (Commits) |
|
Bitbucket (Commits) |
|
Azure DevOps (Commits) |
|
Jira | N/A |
ClickUp | N/A |
Trello | N/A |
Reporting Use Cases
The Created At field from the Commits dataset is the precise timestamp for when a piece of code was saved, making it the fundamental unit for measuring the rhythm, volume, and patterns of your team's development activity.
Reporting on Activity and Frequency: Its primary use is as a dimension in time-series charts to track development throughput. A column chart with a dimension like
YEAR_MONTH(created_at)and aCOUNT()metric creates a classic "Commit Frequency" report, showing the volume of commits over time. This can also serve as a proxy for the DORA metric, Deployment Frequency, especially when filtered to a main branch.Analyzing Work Patterns: You can perform more granular analysis on your team's work habits. By using custom formulas, you can group commits by the day of the week with a dimension like
DAY_OF_WEEK(created_at)or by the hour of the day withHOUR(created_at)to identify patterns, such as work happening over weekends or consistently late at night.Filtering by Time: As with any timestamp, it is also essential for scoping your reports. You can create widgets that focus on a specific period, such as a sprint or a release cycle, by applying a filter like
Created At in the previous 14 days.
