Grouped Metrics

It's possible to create a grouped metric, which will create an individual metric for each unique tuple in the group by columns. This works exactly like SQL GROUP BY queries.

To create a grouped metric, from Catalog, go to the relevant table, then click New Metric.

1265

This will bring up the New metric dialog. First select the column you want the metric to focus on:

776

Then select the column that you want to group your metric by:

772

Alternately you can also go to an existing metric and use the Edit metric dialog, to select the column that you want to group your metric by.

1245

Each individual group will get its own set of thresholds, alerting you if any specific groups are outside of bounds.

In the example below we have a metric that takes the Average of the HOSPITALIZED_SUSPSECTED_COVID_PATIENTS column grouped by COUNTY.

1252