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

❗️

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.