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.

Configuring the tile

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: Select SQL, enter the query below, then click Execute.

   The query runs against a table called dataset. Queries run using DuckDB, which is PostgreSQL-compatible. Table and column names containing spaces or mixed case must be enclosed in double quotes.

   1. Copy

      SELECT AVG(DeploymentsPerDay) AS avg_deployments_per_day
      FROM (
          SELECT
              DATE_TRUNC('day', "finishTime") 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?