Dimensions and Measures

Dimensions and measures are indicators that enable detailed data analysis in reports.

• Dimension — a categorical attribute used to segment data (e.g., store type, region, manager, month)
• Measure — a quantitative value that is calculated, measured, or compared (e.g., revenue, number of sales, average duration, conversion rate)

Dimensions and measures can be created and configured at different system levels:

• At the workspace level (during Data model setup)
• At the dashboard level
• At the widget level

The method of creating an indicator depends on the system level and required customization depth:

1. Tables — widget-level dimensions and measures created directly from columns in the Data Model tables during widget configuration.
2. Groups — reusable indicators predefined at the dashboard or workspace level (can be reused across multiple widgets).
3. Process-based dimensions and measures — indicators derived from process events (available in beta).
4. Hierarchy — a special dimension type for multi-level drill-down analysis.
5. Custom — creation of a custom indicator using a formula.

Widget-Level Dimensions and Measures

To create an indicator at the widget level:

1. In edit mode, create a new widget or select an existing one.
2. On the right-side panel, click + Dimension or + Measure.
3. In the Tables dropdown, select the desired table and column to serve as the indicator.

For certain local indicators, you can:

• Hide empty values
• Enable array nesting
• Configure click actions
• Set a display condition (Always / By variable / By formula)
• Define custom format and formatting by clicking the fx button next to the field. A question mark appears next to the Formatting label—click it to view available formats. Formatting guidance is also available in the formula editor

Array Nesting

The Array nesting toggle is available when a dimension’s formula uses a table column whose data type in the Data Model is an array (Array).

The screenshot below shows the toggle location and the appearance of a Table widget before enabling nesting.

Example of Array Nesting Usage

The following example demonstrates how to use array nesting.

1. Enable the Array nesting toggle. The table layout will change.
2. Publish the dashboard.
3. Click the desired value in the column and confirm your selection.
4. The system will drill down one level deeper.

Drill-down uses click filtering. To return one or more levels up, deselect the filter value in the top panel.

Group Dimensions and Measures

Group dimensions and measures are reusable indicators defined in advance and available across widgets. They can be configured either at the dashboard or data model level, depending on intended scope.

Dashboard Dimensions and Measures

Dashboard-level dimensions and measures are available to all widgets within the current dashboard and help quickly assemble a consistent set of indicators for reporting.

They are configured in the left-side indicators panel via table columns.

To add a dashboard dimension, click + Dimension and specify:

• Name
• Formula
• Format (if only one format is available, this field is hidden)
• Formatting (depends on the selected format)

To add a dashboard measure, click + Measure and define:

• Name
• Formula
• Format (if applicable)
• Formatting (depends on the selected format)

Workspace Dimensions and Measures

Workspace dimensions and measures are defined at the data model level and available across all dashboards in the workspace. Use this level when an indicator must be consistent across multiple dashboards.

To create such an indicator, open the Data model tab in the workspace profile and click the Indicators section in the left panel.

Dimensions and measures are created via the Custom option or directly from table columns.

Workspace indicators can be grouped. By default, they are placed in the Common group, which cannot be deleted or renamed. To create a new group, click + next to the Common group name. To save the group name, press Enter or click the green checkmark.

To delete or rename a group, click the context menu icon and select the appropriate option.

Process-Based Dimensions and Measures

You can add dimensions and measures based on process metrics, enabling faster report creation without manually writing formulas.

Available process-based dimensions include:

• Event start and end times
• Number of executions or reworks for a specified process event
• Custom aggregations (select a table and column for calculation)

For event start and end times, you can apply DateTime transformations such as: date and time, date, year, year and quarter, quarter, year and month, month, day of month, week, day of week, and hour.

After selecting a transformation, choose a process and event. In the Formula field, you can modify the transformation or define a custom one. Clicking + Filter allows you to add a filter based on a dashboard indicator or a table column from the Data Model.

Available process-based measures include:

• Conversion rate between two process events (displayed as a Percentage by default)
• Average and median duration between process events, with options to select the first or last occurrence (aggregation options: avg, median)
• Aggregation over a selected table column

After selecting a metric, choose a process and its event for the widget. Clicking the Formula parameter allows you to change the previously selected metric. Template-based metrics can be converted into editable formulas by selecting Custom from the list.

Some process-based metrics offer additional settings:

• Format
• Formatting
• Filtering (+ Filter button). The Tables group includes tables that:
  • Are used in the process selected in the In process field
  • Are linked to this process via outgoing relationships
• Units (for non-Auto formatting types)
• Hide empty values

Aggregations for Process-Based Dimensions and Measures

Aggregations can be created for both process-based dimensions and measures. When selecting Aggregation, the following options are available:

• Number of executions
• Number of reworks
• Table selection followed by column selection. Available tables are those that:
  • Are used in configured processes within the workspace
  • Are linked to these processes via outgoing relationships

When creating an aggregation via Number of executions or Number of reworks, the widget receives a corresponding formula. Configurable parameters include:

• Name
• Process selection
• Event selection
• Formula:
  • Number of executions (template metric)
  • Number of reworks (template metric)
  • Custom (converts the template into an editable formula)
• Secondary aggregation (defaults to median for count-based template metrics)
• Formatting (available for local measures)
• + Filter button. The Tables group includes tables that:
  • Are used in the process selected in the In process field (for conversion: Start and End fields)
  • Are linked to this process via outgoing relationships

When creating a custom aggregation based on a Data Model table column, configure the following fields:

• Name
• In process — select a workspace process
• For event — select an event from the process. You can calculate the formula for the selected or any event in the process
• Formula (available functions depend on the column’s data type)
• Format
• Formatting

Creating an Aggregation via Column Selection

When creating an aggregation by selecting a column, the following data types are supported:

• Integer/Float
• String
• Date
• DateTime

Settings for Process-Based Dimensions

Select a column; the system suggests transformation options and available aggregate functions. The aggregation set depends on the column’s data type.

Settings for Process-Based Measures

Select a column, then define the primary aggregation and, if needed, a secondary one. Available secondary aggregation functions depend on the result type of the first aggregation.

Hierarchy Configuration

Hierarchy is a dimension type designed for deep drill-down analysis. For example, you can use a hierarchy to display and analyze an entire company structure within a single indicator.

Hierarchies are built using workspace indicators, dashboard indicators, table columns, or the Custom option. To create a hierarchy, in the Dimension indicator, click Add and select Hierarchy. Specify:

• Name
• Dimensions

Hierarchy Behavior

When creating a hierarchy, specify the order of dimensions to ensure correct drill-down sequence.

To expand a hierarchy, click the indicator in the dashboard while in view mode. The hierarchy acts as a filter: widgets update upon clicking a value.

The widget you clicked updates after confirming with the checkmark.

If a second, non-hierarchical indicator is added to the dimension, the hierarchy behaves as a regular filter.

Custom Indicator

A custom indicator allows you to manually create a dimension or measure using formulas, variables, or combinations of multiple fields. This approach is used for non-standard calculations and unique scenarios where predefined columns or template metrics are insufficient.

Indicators are built in the formula editor: when adding a dimension or measure, select Custom and define an expression by combining fields and variables. Custom indicators can be created at the widget level or defined for the entire dashboard or workspace.

When creating a measure, you can configure it through the UI: select a column, then choose a calculation type (e.g., aggregation) from the available options. To switch to manual configuration, expand the Formula field and select Custom. The standard template will automatically convert into an editable formula that you can modify in the formula editor.