Skip to main content

Commits > Author

Tom Williams avatar
Written by Tom Williams
Updated over 3 weeks ago

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)

author

Gitlab (Commits)

author

Bitbucket (Commits)

author

Azure DevOps (Commits)

author
​
​ADO does not attach commits to ADO users. Only a name and email are available. A user lookup is performed to retrieve the user based on the author's email address, but this match only works if the commit author's email in git is the same as the ADO user's email.

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 Author as a dimension is the primary way to visualize who is contributing code and where.

    • Commits per Developer: A bar chart with Author as the dimension and COUNT() as the metric will show the total number of commits per person.

    • Work Distribution: A heatmap with Author as one dimension and Project as 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.

Did this answer your question?