Null percent metrics measure the percent of a column's values that are null.

Create a null percent metric

1. In the Explorer tree, select the data asset that you want to measure.

2. On the asset's Explorer menu select + Create Metric:

   

3. The metric configuration form opens. Set Metric type to Null percent

4. Enter a Metric name.

5. By default, new metrics go Live shortly after you create them. If you want the metric to start off paused, under Metric status, set Status to Paused.

6. If desired, change the value of Quality dimension. Each data quality metric measures one dimension of data quality: accuracy, completeness, timeliness, or (if none of these applies), custom. You can sort and filter your metrics by dimension, and you can view them summarized by dimension in a data quality dashboard.

7. Select Next to proceed to Step 2 (Configure Metric).

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

Optional configuration

1. Add a WHERE clause
2. If needed, override the inherited table configuration
3. Add slices
4. Add seasonality
5. Adjust the backfill duration
6. Choose a missing value filling
7. Add a failing records query
8. Add tags

Preview

Once you have configured your metric you can preview it to view a live query without creating a datapoint. If the preview doesn't work the way you want, you can select the tab for a previous step and modify the configuration as needed.

1. On the Step 3 (Preview) tab, set the date range for the preview, then select Preview.
2. When you're happy with the result, select Next to continue.

You don't have to preview your metric— you can just click Next to proceed to Step 4 (Related metrics).

Add Related metrics

You add related metrics at Step 4 of metric configuration. Related metrics always appear in the list of metrics available during incident analysis.

• To add a related metric, select Add + and then choose a metric in the listbox that appears.
• Select Show info inside a related metric to display the metric's ID and data asset(s).
• When you've added the related metrics you want, select Create (for a new metric) or Save.
• During incident analysis of the metric, any related metrics appear in the metrics listed on the left. You can then easily add them to the Metrics of interest, making the metric chart available within the incident.