Distribution metrics

Use a distribution metric to check the distribution of categories in a category column (i.e., a column with a relatively stable set of possible values) or the distribution of numerical values in a fact column (i.e., a column with significant variability), over time. To create one, begin at Create a metric, and choose Distribution at Step 1 (Metric Info).

1019

Example of a categorical distribution metric.

❗️

Don't create a distribution metric on an ID column.

Step 2 (Configure Metric)

After you finish Step 1 (Metric Info), Step 2 (Configure Metric) appears in the main form:

  1. Under Select data asset, make sure the right data asset is selected.
  2. Perform any optional configuration, as described below, then select Next to proceed to Step 3 to preview your metric.

Optional configuration

  1. Add a WHERE clause.
  2. Adjust the inherited table settings.
  3. Add a slice column.
  4. Add seasonality.
  5. Adjust the backfill duration.
  6. Add a failing records query.
  7. Add tags.

Step 3 (Preview)

Once you have configured your metric you can preview it to view its behavior over some time period. Review its behavior, modify the configuration if necessary, and then save it.