How to chart user activity

A customer asked how to see a report of the number of tickets each user has created.

This can be done by combining Parameter Values with Azure DevOps Queries:

There are four steps to take:

1. In DevOps, create a custom field called TicketLog Creator (or similar). Make sure this is added to the workitem type of your service desk's target project.

2. In TicketLog, configure each form in the service desk to have the custom field set to a parameter value. Select Username or User email.
3. In DevOps, create a new Query that selects the workitem types you want in your report. Make sure to add the custom field to the columns of the query, and any filters you'd like.

4. Select the Charts tab in the query and add a chart. Select your custom field as the Group by field. Save the chart and check it works as expected.

Additionally, if you'd like the chart to appear on a dashboard, add the 'Chart for Work Items' widget to the dashboard and configure the same way.

To use queries on a dashboar widget, you must move the query to Shared Queries.