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. If needed, override the inherited table configuration.
3. Add a slice column.
4. Add seasonality.
5. Adjust the backfill duration.
6. Choose a missing value filling.
7. Add a failing records query.
8. 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 and modify the configuration as needed. When you're happy with the preview, select Next to continue.

You don't have to preview your metric— just click Next to proceed to Step 4.

Step 4 (Related metrics)

You can add related metrics to help streamline your analysis of any incidents identified by the metric. For steps, see Related metrics.