Dimensions and Measures

In this article

Dimensions and Measures

Dimensions and measures of a dashboard are indicators that enable detailed reporting. They are configured in the indicator tab using table columns via the Custom and Quantity options.

To add a dashboard dimension, click + Dimension and specify values for the following fields:

Title
Formula
Format (the field is hidden, if only one format is available for the dimension)
Formatting (depends on the selected format)

To add a dashboard measure, click + Measure and specify values for the following fields:

Title
Formula
Format (if available)
Formatting (depends on the selected format)

Local Indicators

Local indicators are widget-specific indicators, including dimensions and measures. To create a local indicator, click a widget and add a dimension or measure.

For certain local dimensions, you can:

Hide empty values
Enable array nesting
Define click actions
Configure a display condition (Always / By variable / By formula)

Array Nesting

The Array nesting switcher is available if:

Values in the table column within the Data Model are arrays
The column data type is Array(String)
The dimension formula references a table column containing array values

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

The nesting functionality is illustrated in the following example.

Enable the toggle. The table appearance changes.
Publish the dashboard.
Click a value in the column and then click the green checkmark.
The view drills down one level.

Drill-down uses the click filter. To navigate back one or more levels, click the corresponding cross icon in the top panel.

Note

Drill-down does not occur, when multiple values from the same level are selected.

Dimensions and Measures Based on Process Indicators

Note

These features are available in beta version. Try them in your workflows and share your feedback — your input helps us improve the product.

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

Available process-based dimensions include:

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

For event start and end times, the following DateTime transformation options are available: date and time, date, year, year and quarter, quarter, year and month, month, day of month, week, day of week, and hour.

Available process-based measures include:

Conversion rate between two process events. By default, displayed in Percentage format. The value is multiplied by 100 and a % symbol is appended
Average and median duration between process events, with the option to select the first or last occurrence of an event. Aggregation options include avg and median
Custom aggregations (select a table and column for calculation)

After selecting an indicator, choose the processes and their associated events to display in the widget. Clicking the Formula parameter allows you to modify the previously selected indicator type. Template-based indicators can be converted into editable formulas by selecting Custom from the list.

Additional settings may be available for certain process indicators:

Format
Formatting
Filtering (+ Filter button)
Units (for all formatting types except Auto)
Hide empty values

Aggregations in Process Indicators

Aggregations in process indicators can be created for both dimensions and measures. When selecting Aggregation from the list, the following options are available:

Number of executions
Number of overtimes
Select a table and a column

When creating an aggregation via Number of executions or Number of overtimes, the widget receives an indicator with the corresponding formula. The following parameters are configurable:

Title
Process selection
Event selection
Formula
- Number of executions (template indicator)
- Number of overtimes (template indicator)
- Custom (converts the template indicator into an editable formula)
Secondary aggregation (for template indicators, median is selected by default)
Formatting (available for local measures)
+ Filter button

Creating an Aggregation by Selecting a Column

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

Integer/Float
String
Date
DateTime

Dimension Settings

After selecting a column, transformation options appear, followed by aggregate function options. The aggregation list includes standard functions corresponding to the selected column’s data type.

Data Type	Transformation Options	Aggregation Options
Integer/Float	—	avg median count count(distinct) min max sum top firstValue lastValue
String	—	top firstValue lastValue
DateTime	Date and time (dateTime) Date (date) Year (year) Year and quarter (yearAndQuarter) Quarter (quarter) Year and month (yearAndMonth) Month (month) Day of month (dayOfMonth) Week (week) Day of week (dayOfWeek) Hour (hour)	top firstValue lastValue
Date	Date (date) Year (year) Year and quarter (yearAndQuarter) Quarter (quarter) Year and month (yearAndMonth) Month (month) Day of month (dayOfMonth) Week (week) Day of week (dayOfWeek)	top firstValue lastValue

Measure Settings

After selecting a column, options for the first and second aggregations appear. The second aggregation options include standard functions corresponding to the result type of the first aggregation.

Data Type	First Aggregation Options	Second Aggregation Options
Integer/Float	avg median count count(distinct) min max sum top firstValue lastValue	avg median count count(distinct) min max sum
String	count count(distinct) top firstValue lastValue	count count(distinct) top
DateTime	count count(distinct) min max top firstValue lastValue	count count(distinct) min max
Date	count count(distinct) min max top firstValue lastValue	count count(distinct) min max

Configuring Hierarchy

A hierarchy is a dimension type designed for in-depth report analysis. For example, a hierarchy can display an organization’s structure within a single indicator for comprehensive analysis.

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