In this article you'll learn about the built-in metrics you can configure in Toro without writing a line of code.

Learn how to use Filters and Dimensions to customize how these metrics are collected, in Metrics 101 [LINK TO ARTICLE HERE].

Learn how to write custom metrics using SQL in our Custom Metrics 101 article [LINK TO CUSTOM METRICS101 ARTICLE].

We're adding new metrics all the time. Have an idea for a new metric? Send us an email at support@torodata.io!


Any column type

Count

Count reports a simple count of rows, and can be applied to any column in the table. 

Cardinality

Cardinality reports the count of distinct values in the chosen column. 

Nulls (count)

Nulls (count) reports the percent of null values.

Note that this only reports true nulls, and you may want to pair it with an Empty String metric on string columns.

Nulls (%) 

Nulls (%) reports the percent of values that are null.

Note that this only reports true nulls, and you may want to pair it with an Empty String metric on string columns.

Whitelist (%)

Whitelist reports the percent of values that matched one of the values in a whitelist you provide. This metric is helpful for getting a heads up when a new value has appeared in an enum column, such as region names, product names, or event names.


Numeric columns

Average

The average of all the values included in the metric calculation.

Min

The min value among all the values included in the metric calculation.

Max

The max value among all the values included in the metric calculation. 

Sum

The sum of all the values included in the metric calculation.

Example: configuring a Sum metric on your charge_amount column in the user_billings table, with a 7-day filter, would report the rolling 7-day total amount charged.


String columns

Empty string (count)

The count of values that are empty strings. Note that these are different from nulls, and you should usually pair this metric will a Null (%) or Null (count) metric on the same column.

Empty string (%) 

The percent of values that are empty strings. Note that these are different from nulls, and you should usually pair this metric will a Null (%) or Null (count) metric on the same column. 


Timestamp columns

Freshness (hours) 

Freshness reports the difference, in hours, between now and the latest timestamp in the column.

This metric is useful for monitoring table refresh times, by monitoring a whichever column represents the time the records were written. At Toro, we monitor the _loaded_at column in our sales demo tables, to make sure they're being refreshed every 4 hours.


Boolean columns

True (%)

The percent of values that are TRUE.

True (count)

The number of values that are TRUE. 

False (%)

The percent of values that are FALSE.

False (count)

The number of values that are FALSE. 



We're adding new metrics all the time. Have an idea for a new metric? Send us an email at support@torodata.io!

Did this answer your question?