Create and Explore Metrics

What is a Metric?

A metric is a SQL expression of business logic. It indicates how to perform a timeseries aggregation in order to calculate a KPI using a dataset. By creating metrics in Rasgo, you can standardize the logic of how to calculate KPIs for your organization.
Rasgo metrics are directly compatible with dbt metrics, and can be exported to your dbt project manually via our git integration.

Creating Metrics

To create metrics, open a published dataset and click "Create Metrics":
Metrics can only be created on published datasets.
This will open the "Manage Metrics" menu where you can provide the metadata necessary to create one or more metrics. Here are the properties captured in Manage Metrics:
Time Dimension
The datetime index column of the dataset
One or more dimension columns in the dataset
Column to aggregate to calculate the metric
Aggregation method to calculate the metric
Human-readable label for the metric
Description of how the metric is calculated

Exploring Metrics

Rasgo makes it easy to browse all of your metrics, as well as interactively drill into them to gain quick insights.