Table of Contents

Metrics (Derived)

Metrics in a semantic model enables combining multiple simple metrics from (different) datasets into a single derived metric defined by an expression, for example sales - cost_of_goods_sold where sales and cost_of_goods_sold are simple metrics in one or more datasets in the semantic model.

Before you can define any derived metrics, you must add at leas one Dataset with a simple metric.

Important

To use metrics from different datasets in the same expression, it is required that they share at least one common column relationship.

Properties

Name Description
Name The name of the metric as presented to the AI agent. Use a descriptive name to help the agent understand how to use the metric.
Description Optional, but recommended. A short, informative description that helps the AI agent understand what the metric represents and how to use it.
Expression The formula of the metric. You can use numbers and simple metrics defined in datasets as operands. Allowed operators are +,-,*, / and parentheses for grouping.

Example: (sales - cogs) / sales * 100, where sales and cogs are metrics defined in one or more datasets.
Synonyms Optional. A list of alternative terms for the metric Name. Add synonyms when several terms are commonly used for the same metric, so the AI agent can pick the correct metric from a user request.