Yandex Cloud
Search
Contact UsGet started
  • Blog
  • Pricing
  • Documentation
  • All Services
  • System Status
    • Featured
    • Infrastructure & Network
    • Data Platform
    • Containers
    • Developer tools
    • Serverless
    • Security
    • Monitoring & Resources
    • ML & AI
    • Business tools
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Customer Stories
    • Cloud credits to scale your IT product
    • Gateway to Russia
    • Cloud for Startups
    • Education and Science
    • Yandex Cloud Partner program
  • Blog
  • Pricing
  • Documentation
© 2025 Direct Cursus Technology L.L.C.
Yandex DataLens
    • Overview
    • Formula syntax
    • Parameters
  • Audit Trails events

In this article:

  • Calculated fields in datasets
  • Calculated fields in charts
  • Functions
  • Notation format
  • How to create a calculated field
  1. Calculated fields
  2. Overview

Calculated fields

Written by
Yandex Cloud
Updated at March 6, 2025
  • Calculated fields in datasets
  • Calculated fields in charts
  • Functions
    • Notation format
  • How to create a calculated field

A calculated field is an additional data field with values calculated using a formula.
You can use calculated fields to create new dimensions and measures. The data source remains unchanged.

To write formulas, you can use the existing dataset fields, parameters, constants, and functions.

You can create calculated fields in the dataset or wizard interface:

  • Calculated fields from a dataset are available in all charts above this dataset.
  • Calculated fields from the wizard are only available for saved charts.

Calculated fields are marked with .

Calculated fields in datasetsCalculated fields in datasets

You can add new fields to a dataset field list.

When creating a formula, you can use any dataset field, including the calculated fields you previously created. In a formula, you can also use parameters created at the dataset level.

After creating a calculated field and saving the dataset, the field becomes available to all charts and dashboard selectors based on that dataset.

To hide fields in the wizard, enable the Do not display in wizard option when creating them.

Calculated fields in chartsCalculated fields in charts

You can add new fields when creating and editing charts in the wizard:

  • In the list of fields from a dataset.
  • In the visualization section.

When creating a formula, you can use any dataset field, including the calculated fields you previously created. In a formula, you can also use the parameters of the chart or dataset based on which the chart is created.

If a field is created in a chart, it will not be available to dashboard selectors and other charts.

Warning

In multi-dataset charts, calculated fields are not applicable to fields from multiple datasets.

FunctionsFunctions

Functions are the principal components used for creating formulas. You can use them to perform various operations on data fields.

The list of available functions depends on the data source. For more information, see Function Availability.

Warning

Avoid calculation loops: in a formula, you cannot use a field that uses the same formula to calculate its own value.

Notation formatNotation format

Write formulas according to the following requirements:

  1. Specify function arguments in parentheses, e.g., YEAR([DATE1]). Separate multiple arguments with commas.
  2. Specify field names in square brackets, e.g., [CustomerID].
  3. Make sure to enter the values of fields and constants in a valid format. For example, use a period as a decimal separator: 0.123.

Note

  • Field name syntax is case-sensitive. For example, if the formula uses [NAME], while the dataset contains only [Name], the formula field will be highlighted in red.
  • Function syntax is not case-sensitive. For example, count and COUNT will perform the same operation.

For more information on format, types of accepted arguments, and returned function values, use the Reference button when adding a field in the formula editor interface.

How to create a calculated fieldHow to create a calculated field

You can create calculated fields in the dataset or wizard interface.

Datasets
Wizard

Warning

If you use a new DataLens object model with workbooks and collections:

  1. In the left-hand panel, select Collections and workbooks.
  2. Open the appropriate workbook and select an object.

Follow the guide from step 2.

  1. In the left-hand panel, click Datasets and select the dataset you need. If you do not have a dataset, create one.
  2. In the top-right corner, click Add field.
  3. Enter a name for the field.
  4. Select Formula as the data source for the field.
  5. Add the formula using data source functions.
  6. Click Create. The field will appear in the dataset.

dataset-calculated-field

Warning

If you use a new DataLens object model with workbooks and collections:

  1. In the left-hand panel, select Collections and workbooks.
  2. Open the appropriate workbook and select an object.

Follow the guide from step 2.

  1. In the left-hand panel, click Charts and select the chart created in the wizard.
  2. On the left side of the screen above the list of dataset fields, click and select Field.
  3. Enter a name for the field.
  4. Enter the required formula.
  5. Click Create. The field will appear in the list on the left. You can use it in a chart.

chart-calculated-field

See alsoSee also

  • Creating fields
  • Row-level security (RLS)

Was the article helpful?

Previous
Data type mapping
Next
Formula syntax
© 2025 Direct Cursus Technology L.L.C.