Deployment frequency

This tile shows the average number of deployments per day within the selected timeframe. It provides a simple indicator of delivery throughput and helps teams quickly understand whether deployment frequency is increasing or declining.

Configuration

Configure the following in the tile editor:

1. Data Source: Select Azure DevOps.
2. Data Stream: Select Build Runs.
3. Objects: Select the projects you want data from.
4. Parameters > Result: Select Succeeded to filter by successful deployments.

5. Timeframe: Select the timeframe you want to track. Note that after adding a monitor or configuring a KPI the Use dashboard timeframe option is disabled.

6. Filter | Group | Sort: Enable the SQL toggle then enter the following query and click Execute:
   
   Copy

   SELECT AVG(DeploymentsPerDay) AS avg_deployments_per_day
   FROM (
       SELECT
           DATE_TRUNC('day', finish_time) AS Day,
           COUNT(*) AS DeploymentsPerDay
       FROM dataset
       GROUP BY Day
   );

7. Visualization: Select Scalar.
   1. Mapping > Value: Auto - Avg Deployments Per Day is automatically selected.
8. Click Save.

Was this article helpful?