Skip to main content

Metric Settings

Introduction

In charts, dimensions determine how data is analyzed, while metrics determine which values are displayed.

This article introduces metric settings for charts on pages and custom data details pages, including regular metrics, aggregate filters, and calculated metrics.


Use Cases

  • In a sales dashboard, use metrics to calculate sales amounts, average order values, and order counts by region.

  • In profit analysis, add calculated metrics to calculate gross profit margins and output per employee.

  • Use aggregate filters to compare order counts in East Europe and North Europe within the same chart, without adding multiple charts or splitting data sources.


Terminology

Term

Description

Example

Metric

Aggregates a field from the data source to obtain a value displayed in the chart.

Sum the Sales Amount field to get the total sales amount.

Aggregation Method

The calculation method used to aggregate a field.

Sum, Average, Count, etc.

Aggregate Filter

Specifies the data range for an individual metric.

Count only orders from East Europe.

Calculated Metric

Calculates existing fields to obtain a new metric when the data source does not contain the required data.

Subtract the total cost from the total sales amount to calculate gross profit.


Metric Settings

Adding Metrics

After adding a chart component, click Add in the metric settings area and select the field to aggregate. If the data source does not contain the required field, you can add a Calculated Metric to calculate a new value based on existing fields.

Metric Settings

After adding a metric, click it to configure the following settings:

Setting

Description

Display Name

Changes the name displayed in the chart without changing the original field name.

Aggregation

Selects how to aggregate the field, such as summing sales amounts or counting order numbers.

  • Number fields support Sum, Average, Max, Min, and Count.

  • For non-number fields, fields in the main form support Count and Dedupe, while subform fields support only Count.

Aggregation Conditions

Specifies the data range for the current metric.

Advanced Computing

Performs further calculations on aggregated results, such as proportions and rankings.

Data Display Format

Sets how values are displayed, such as decimal places, percentages, and thousand separators.

Setting Aggregation Conditions

Aggregate filters specify the data range for an individual metric. They are useful for comparing different data ranges in the same chart. Each metric's aggregate filter applies independently and does not affect other metrics in the chart.

Click a metric and select Aggregate Filter in the expanded panel. Add filter conditions as needed.

Note: Data source filters affect the data range of the entire chart, while aggregate filters affect only the current metric.


Calculated Metric Settings

If the data source does not contain the data required for analysis, you can add a calculated metric to calculate a new value based on existing fields.

Adding a Calculated Metric

After adding a chart component, click Add in the metric settings area and select Calculated Metric to open the formula editor.

Editing Formulas

In the formula input area, you can use aggregate variables, numbers, arithmetic operators (+, -, *, /), and parentheses to write formulas.

An aggregate variable is the result of aggregating a field. Each aggregate variable requires its own aggregation method and aggregate filter:

  • Aggregation Method : Sum, Average, Count, Max, and Min.

  • Aggregation Conditions : Filters data that meets the specified conditions before aggregation.

For example, the gross profit margin can be calculated using the following formula: (SUM(Sales Revenue) - SUM(Sales Cost)) / SUM(Sales Revenue)

Notes:

  • A formula must contain at least one aggregate variable.

  • The formula result must be a number.

  • Each field supports up to 10 aggregate conditions.

  • Fields in the main form cannot be calculated together with subform fields.

  • Only fields within the same subform can be used together in calculations.

Did this answer your question?