Skip to main content

Commits > Created at

Tom Williams avatar
Written by Tom Williams
Updated this week

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)

created_at

Gitlab (Commits)

created_at

Bitbucket (Commits)

date

Azure DevOps (Commits)

committer.date

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 a COUNT() 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 with HOUR(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.

Did this answer your question?