Skip to main content

18 docs tagged with "Metrics"

View all tags

Creating metrics

Define metrics in your dbt project to create quantitative indicators.

Derived metrics

Derived metrics is defined as an expression of other metrics..

Dimensions

Dimensions determine the level of aggregation for a metric, and are non-aggregatable expressions.

Entities

Entities are real-world concepts that correspond to key parts of your business, such as customers, transactions, and ad campaigns.

Joins

Joins allow you to combine data from different tables and create new metrics

Measures

Measures are aggregations performed on columns in your model.

MetricFlow commands

Query metrics and metadata in your dbt project with the MetricFlow commands.

Ratio metrics

Use ratio metrics to create a ratio out of two metrics.

Saved queries

Saved queries are a way to save commonly used queries in MetricFlow. They can be used to save time and avoid writing the same query over and over again.

Semantic models

Semantic models are YAML abstractions on top of a dbt model, connected via joining keys as edges

Simple metrics

Use simple metrics to aggregate data directly from columns in your semantic models.

Validations

The Semantic Layer, powered by MetricFlow, has three types of built-in validations, including Parsing Validation, Semantic Validation, and Data Warehouse validation, which are performed in a sequential and blocking manner.