Dataset: Commits from pull requests
Entity: Commit
Field ID: author_username
Type: Text
Description: The username of the person who created the commits. Note that usernames are app-specific.
Source: App
From: |
|
Github (Commits) |
|
Gitlab (Commits) |
|
Bitbucket (Commits) |
|
Azure DevOps (Commits) |
If no match is found, the commit user will be attached to a generic user built based on their name and email address. |
Jira | N/A |
ClickUp | N/A |
Trello | N/A |
Reporting Use Cases
The Author field from the Commits dataset is the definitive attribute for identifying who wrote a specific piece of code. It is essential for analyzing individual contribution patterns, tracking workload at the code level, and filtering out automated activity.
Filtering and Scoping: You can create highly focused reports by including or excluding commits from specific authors.
Individual Contribution Reports: To analyze the work of a single developer, you can apply a filter like
Author = "john.doe".Exclude Bot Commits: A crucial use case is to clean your data by removing automated commits (e.g., from dependency updates). You can do this with a filter like
Author !~ "bot".Personal Dashboards: Use the is me operator to create a widget that shows all the commits you have personally authored.
Reporting on Contribution Patterns: Using
Authoras a dimension is the primary way to visualize who is contributing code and where.Commits per Developer: A bar chart with
Authoras the dimension andCOUNT()as the metric will show the total number of commits per person.Work Distribution: A heatmap with
Authoras one dimension andProjectas the other can reveal which developers are the primary contributors to which repositories, helping you identify code ownership and knowledge silos.
Creating Advanced KPIs: You can use this field within aggregations to measure the breadth of your team's contributions.
Active Contributor Count: A KPI with the custom formula
COUNT_DISTINCT(author_username)will tell you the number of unique developers who have committed code in a given period, which is a great way to measure team engagement.
