Custom SLAs

Custom SLAs allow you to track how your group is performing relative to configurable thresholds for metrics not already available with standard SLAs. By providing your own SQL query, you can create agreements on how you want to work and monitor how your team is performing against them.

Create a custom SLA

To create a custom SLA for your group:

  1. Go to DX → Dashboard → SLAs.
  2. Click the + Custom SLA button at the end of the list.
  3. Configure the options.
  4. Click Create.

Options

  • SLA name: The display name for the custom SLA.
  • SQL query: The query that returns the SLA items to check. See query format.
  • Goal: How the SLA should compare metric values against the threshold to determine whether they meet the target.
  • Threshold: The baseline value to compare metric values to.
  • Unit label: The unit label to display with metric values.
  • Item name: The name to display for items.

SQL query format

Your SQL query must return results in the exact format below. Queries that don’t match this structure will display an error.

Each row represents an SLA item to check (e.g., a PR, issue, etc.) and must include the following columns:

Column Type Description
id string or numeric A unique identifier for the item.
title string A readable name for the item.
value numeric The metric value to compare against the SLA target.
resolution_date datetime When the item was resolved, or NULL if still unresolved.
external_url string (Optional) A URL to follow when clicking on items.
user_id integer (Optional) The id of the corresponding user row in dx_users. If provided, the value will be used to automatically scope data to your members of your group. If not provided, your query must be pre-scoped to your group.

Query limits: To maintain dashboard performance, SQL queries are limited to a maximum of 2,000 items. Results exceeding this limit will be truncated.

Edit/delete custom SLAs

To edit or delete a custom SLA for your group:

  1. Go to DX → Dashboard → SLAs.
  2. Locate the custom SLA you wish to edit or delete and click the ••• button on its right.
  3. Click either Edit or Delete.