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.
This will bring up the New metric dialog. First select the column you want the metric to focus on:
Then select the column that you want to group your metric by:
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.
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.
Updated about 1 year ago