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.

Deployment frequency is one of the four DORA metrics. This tile calculates it by counting the deployments that completed on each day of the selected timeframe and then averaging those daily counts, so a single busy day does not distort the figure.

There is no universal target. The DORA research bands run from fewer than one deployment a month at the low end to several a day at the high end, so the useful comparison is against your own trend rather than an industry number. A falling average is worth investigating even while it sits inside a range you consider healthy.

Configure the data

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
      );

Visualize the data

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

2. Click Save.

Was this article helpful?