Dimensions and Measures in YAML

The value Key

Predefined Formulas (templateName) by Data Type

The value Key in eventMeasures

The value Key in transitionMeasures

# Dimensions and Measures in YAML

Dimensions and measures are defined in YAML format under the `value` key. This page describes the key-value pairs used within this key for various widget types. Dashboards are built from KPI widgets, process widgets, tables, charts, and auxiliary widgets. For more details, see [Widgets](../2.1.Edit_mode/21.Widgets.md).

Process widgets use process stages and associated metrics. Stages and their indicators are configured via `eventMeasures` and `transitionMeasures`, which use specific settings.

## The value Key

The table below describes parameters for standard dimensions and measures in widgets.

| **Key** | **Type** | **Definition** |
|---|---|---|
| `mode` | enum | Calculation mode: `TEMPLATE` or `FORMULA` |
| `tableName` | string | Table name (only for `mode: TEMPLATE`) |
| `columnName` | string | Column name (only for `mode: TEMPLATE`) |
| `templateName` | enum | Predefined formula (only for `mode: TEMPLATE`) |
| `formula` | string | Calculation formula (only for `mode: FORMULA`) |

Example of dimension/measure usage:

```yaml
value:
 mode: TEMPLATE
 templateName: countDistinct
 tableName: case_table
 columnName: incident_id
```

## Predefined Formulas (templateName) by Data Type

The available set of predefined formulas (`templateName`) depends on the data type of the [dimension or measure](../2.1.Edit_mode/25.Dimensions_and_measures.md).

| **Data Type** | **Dimension Formula** | **Measure Formula** |
|---|---|---|
| STRING | — | `count`, `countDistinct` |
| INTEGER | — | `avg`, `median`, `count`, `countDistinct`, `min`, `max`, `sum` |
| FLOAT | — | `avg`, `median`, `count`, `countDistinct`, `min`, `max`, `sum` |
| DATE | `date`, `year`, `yearAndQuarter`, `quarter`, `yearAndMonth`, `month`, `dayOfMonth`, `week`, `dayOfWeek` | `count`, `countDistinct`, `median`, `min`, `max` |
| DATETIME | `dateTime`, `date`, `year`, `yearAndQuarter`, `quarter`, `yearAndMonth`, `month`, `dayOfMonth`, `week`, `dayOfWeek`, `hour` | `count`, `countDistinct`, `median`, `min`, `max` |
| DATETIME64 | `dateTime`, `date`, `year`, `yearAndQuarter`, `quarter`, `yearAndMonth`, `month`, `dayOfMonth`, `week`, `dayOfWeek`, `hour` | `count`, `countDistinct`, `median`, `min`, `max` |
| BOOLEAN | — | `count`, `countDistinct` |
| OTHER | — | `count`, `countDistinct` |

## The value Key in eventMeasures

The `eventMeasures` key is used in [Process Card](../2.1.Edit_mode/2.Process_card.md) and [Processes Sphere](../2.1.Edit_mode/13.Processes_sphere.md) widgets. The dimension and measure parameters configured in `eventMeasures` are listed in the table below.

| **Key** | **Type** | **Definition** |
|---|---|---|
| `mode` | enum | Formula type: - `TEMPLATE` - `FORMULA` |
| `templateName` | string | Template name (only for `TEMPLATE`) Available templates: 1. `eventsCount` (Number of events) 2. `reworksCount` (Number of reworks) |
| `formula` | string | Formula (only for `FORMULA` mode) |

## The value Key in transitionMeasures

The `transitionMeasures` key is used in [Process Card](../2.1.Edit_mode/2.Process_card.md) and [Processes Sphere](../2.1.Edit_mode/13.Processes_sphere.md) widgets. The dimension and measure parameters configured in `transitionMeasures` are listed in the table below.

| **Key** | **Type** | **Definition** |
|---|---|---|
| `mode` | enum | Formula type: - `TEMPLATE` - `FORMULA` |
| `templateName` | string | Template name (only for `TEMPLATE`) Available templates: 1. `transitionsCount` (Number of transitions) 2. `medianTime` (Median time) |
| `formula` | string | Formula (only for `FORMULA` mode) |

Description of dimensions and measures in YAML

Process-Based Dimensions and Measures in YAML

Widget Configuration in YAML

What Is Operavix

Quick Installation of the Operavix Server Component

Monitoring Agent

JS Tracker (Customer Journey Tracking)

Quick Installation

Quick System Setup

Building a Custom Dashboard

Template-Based Reports for Data Analysis

First Dashboard

What’s Next?

Quick Start 

Functional Architecture

Network Interaction of System Components

Description of the System Functioning

System Integration with External Automated Systems

Technical Requirements for Server and Hardware Equipment

Architectural Scheme of the Operavix Application

Network Scheme of the Operavix Application

Glossary

Description of the Operavix System 

Installing, Configuring, and Removing the Operavix Application on Windows

Installing the Operavix Application on Linux

Updating Operavix on Windows

Updating Operavix on Linux

Updating Operavix

Cluster Mode Setup

Migrating the Operavix Server from Windows to Linux

Installing the Automation Module on a Separate Server

Installing and Running the AI Agent

Installing and Running the Webhook Agent

Instructions for Installing, Updating, and Removing the System

License Key

Beta Version Functionality

System Licensing

Working with Databases

Working with the System

System Configuration Files

Prometheus Metrics

Access Roles

Working with GraphQL

Managing System Users

System Emails to Users

Embedding Operavix Dashboards

Differences Between Operavix on Linux and Windows Operating Systems

Administration 

Installing and Removing the ClickHouse DBMS

Updating the ClickHouse DBMS

Connecting the Application to the ClickHouse Analytical DBMS

Creating User Accounts in ClickHouse

Setting up a ClickHouse DBMS Cluster in Docker with Replication Support

ClickHouse 

User Data Collection by Monitoring Agent

Obtaining The Monitoring Agent Distribution

Monitoring Agent Configurator

Installing, Updating, and Removing the Monitoring Agent on Windows

Installing, Updating, and Removing the Monitoring Agent on Linux

Starting and Stopping the Monitoring Agent

Managing the Monitoring Agent

Monitoring Logs

Storing Monitoring Agent Logs

Collecting Screenshots with the Monitoring Agent

Export and Import of User Activity

Activity Archiving

Working with Damaged Monitoring Archives

Data Storage Structure in ClickHouse

Monitoring 

Signing In to the System

How to Recover Your Password

Home Page

Filtering

Navigation in the System

Workspaces

Personal Profile

System Settings

Users

Departments

Bulk Actions

Adding API Keys

Keytab File Creation for the Kerberos Authentication in Active Directory

Configuring Authentication Using OpenID Connect and Keycloak

Configuring SAML Authentication in Keycloak

Adding Authentication

About the system

The Monitoring Section

The Connections Section

Data Storages

System Tables

System Settings 

Automation Agents

Execution Log

Control Panel

Configuring an SMB Connection

Connections

Automation Blocks

Trigger Blocks

Working with Files

Working with Services

Working with LLM

Tools

Event Processing

Editing a Script

Query and Code Editor

Script Testing and Publishing

Running a Script

Script Example

Automation 

Custom Integrations 

System Events

JS Tracker 

Access Settings for Workspaces

Adding and Configuring Tables

Replacing Tables

Adding and Configuring Processes

Global Workspace Indicators

Display Rules

Configuring the Data Model

Packages

General

Configuring Access to Dashboards

Click to Filter

Table Report Export

Browse mode

Edit Mode

Views

Dimensions and Measures

Widget Basic Settings

Widget Display Settings

Widget Filtering Settings

Widget List

Widgets

Sorting

Markdown Usage Rules

Variables

Global Dashboard Indicators

Running Script from Dashboard

Go to URL

Run Script

Open View

Update Variable

Click Actions

Input Methods

Displaying Monitoring Screenshots in a Dashboard

Formula Editor

Functions for Formulas

The process Function

View Configuration in YAML

Data Formats and Formatting in YAML

YAML Editor

Dashboards

Report Example

Business Intelligence 

OperavixAI

Package Creation Guide

Marketplace 

Template-Based Dashboards

Configuring Depersonalization Of User Data When Deleted In AD

Activating LDAPS

Synchronized Attributes Between the System and AD

Getting Information About AD Security Groups Using A GraphQL Request

Configuring User Synchronization with Active Directory

User Synchronization 

Audit Mechanism Description

System Status Monitoring

Implemented Information Security Protection Measures in the System

Audit Logs

Docker Containers

Mutual Authentication Between Application Server and ClickHouse

For Security Administrator 

Known Issues

Known Issues and Limitations 

Frequently Asked Questions

Key	Type	Definition
`mode`	enum	Calculation mode: `TEMPLATE` or `FORMULA`
`tableName`	string	Table name (only for `mode: TEMPLATE`)
`columnName`	string	Column name (only for `mode: TEMPLATE`)
`templateName`	enum	Predefined formula (only for `mode: TEMPLATE`)
`formula`	string	Calculation formula (only for `mode: FORMULA`)

Data Type	Dimension Formula	Measure Formula
STRING	—	`count`, `countDistinct`
INTEGER	—	`avg`, `median`, `count`, `countDistinct`, `min`, `max`, `sum`
FLOAT	—	`avg`, `median`, `count`, `countDistinct`, `min`, `max`, `sum`
DATE	`date`, `year`, `yearAndQuarter`, `quarter`, `yearAndMonth`, `month`, `dayOfMonth`, `week`, `dayOfWeek`	`count`, `countDistinct`, `median`, `min`, `max`
DATETIME	`dateTime`, `date`, `year`, `yearAndQuarter`, `quarter`, `yearAndMonth`, `month`, `dayOfMonth`, `week`, `dayOfWeek`, `hour`	`count`, `countDistinct`, `median`, `min`, `max`
DATETIME64	`dateTime`, `date`, `year`, `yearAndQuarter`, `quarter`, `yearAndMonth`, `month`, `dayOfMonth`, `week`, `dayOfWeek`, `hour`	`count`, `countDistinct`, `median`, `min`, `max`
BOOLEAN	—	`count`, `countDistinct`
OTHER	—	`count`, `countDistinct`

Key	Type	Definition
`mode`	enum	Formula type: - `TEMPLATE` - `FORMULA`
`templateName`	string	Template name (only for `TEMPLATE`) Available templates: 1. `eventsCount` (Number of events) 2. `reworksCount` (Number of reworks)
`formula`	string	Formula (only for `FORMULA` mode)

Key	Type	Definition
`mode`	enum	Formula type: - `TEMPLATE` - `FORMULA`
`templateName`	string	Template name (only for `TEMPLATE`) Available templates: 1. `transitionsCount` (Number of transitions) 2. `medianTime` (Median time)
`formula`	string	Formula (only for `FORMULA` mode)

.css-wsrjzs{display:inline;margin-right:12px;}@media screen and (max-width: 691px){.css-wsrjzs{display:inline-block;margin-right:0;}}Dimensions and Measures in YAML

The value Key

Predefined Formulas (templateName) by Data Type

The value Key in eventMeasures

The value Key in transitionMeasures

Dimensions and Measures in YAML