Create and Explore Metrics
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.
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:
Property | Description |
---|---|
Time Dimension | The datetime index column of the dataset |
Dimensions | One or more dimension columns in the dataset |
Column | Column to aggregate to calculate the metric |
Aggregation | Aggregation method to calculate the metric |
Label | Human-readable label for the metric |
Description | Description of how the metric is calculated |
Rasgo makes it easy to browse all of your metrics, as well as interactively drill into them to gain quick insights.
Last modified 4mo ago