Yandex Cloud
Search
Discuss with expertTry it for free
  • Customer Stories
  • Documentation
  • Blog
  • All Services
    • Cloud Interconnect
    • Cloud Backup
    • Cloud Registry
    • Yandex AI Studio
    • Compute Cloud
    • Object Storage
    • Managed Service for Kubernetes®
    • Yandex BareMetal
    • Smart Web Security
    • Security Deck
    • Managed Service for PostgreSQL
    • Managed Service for ClickHouse®
    • Monium
    • Cloud CDN
    • Network Load Balancer
    • Virtual Private Cloud
    • Cloud DNS
    • Application Load Balancer
    • Yandex Cloud Video
    • Stackland
    • Yandex Cloud Router
    • Yandex Managed Service for Trino
    • Managed Service for MySQL®
    • Managed Service for Valkey™
    • Managed Service for Apache Spark™
    • Yandex StoreDoc
    • Managed Service for OpenSearch
    • Managed Service for Apache Kafka®
    • Data Transfer
    • Yandex MPP Analytics Engine for PostgreSQL
    • Yandex Managed Service for Apache Airflow®
    • Data Processing
    • Yandex MetaData Hub
    • Managed Service for YDB
    • Managed Service for Sharded PostgreSQL
    • Managed Service for YTsaurus
    • Yandex WebSQL
    • DataLens
    • Yandex Search API
    • SpeechSense
    • SpeechKit
    • DataSphere
    • Vision OCR
    • Translate
    • Yandex Identity Hub
    • Key Management Service
    • Certificate Manager
    • Yandex Lockbox
    • Audit Trails
    • SmartCaptcha
    • Cloud Desktop
    • Yandex SIEM
    • SourceCraft Code Assistant
    • Container Registry
    • Managed Service for GitLab
    • Managed Service for Prometheus®
    • Cloud Functions
    • API Gateway
    • Yandex Cloud Postbox
    • Message Queue
    • Serverless Integrations
    • IoT Core
    • Data Streams
    • Serverless Containers
    • Cloud Notification Service
    • Yandex Query
    • Identity and Access Management
    • Yandex Cloud Console
    • Resource Manager
    • Yandex Cloud Billing
    • Yandex Cloud Quota Manager
    • Cloud Apps
  • System Status
  • Marketplace
    • Featured
    • Infrastructure & Network
    • Data Platform
    • AI for business
    • Security
    • DevOps tools
    • Serverless
    • Monitoring & Resources
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Start testing with double trial credits
    • Cloud credits to scale your IT product
    • Gateway to Russia
    • Cloud for Startups
    • Center for Technologies and Society
    • Yandex Cloud Partner program
    • Price calculator
    • Pricing plans
  • Customer Stories
  • Documentation
  • Blog
© 2026 Direct Cursus Technology L.L.C.
All solutions
    • All solutions for DataLens
    • How to access Yandex Direct from DataLens
    • How to get a token to access a Bitrix24 database from DataLens
    • How to connect to the MoySklad connector
    • How to restore a broken dataset
    • How to recover deleted objects
    • How to find IP addresses used for connecting to external data sources
    • How to filter previously filtered data using a selector
    • Resolving the `ERR.DS_API.FIELD.TITLE.CONFLICT` error
    • Resolving the `ERR.DS_API.REQUEST_TIMEOUT` error
    • Resolving the `ERR.DS_API.SOURCE_CONFIG.TABLE_NOT_CONFIGURED` error
    • Troubleshooting issues while accessing a Google Sheets spreadsheet from DataLens
    • `Total` values in DataLens table charts mismatch the respective data from Yandex Metrica
    • Resolving the `ERR.DS_API.US Not correct folder_id` error
    • Resolving the `ERR.DS_API.FORMULA.TRANSLATION.DATA_TYPE` error
    • Resolving issues with access to the podcast statistics dashboard in Yandex Music
    • Resolving the `ERR.DS_API.FORMULA.VALIDATION.AGG.INCONSISTENT` error
    • Fixing issues when loading a CSV file into a dataset as a data source
    • Resolving the `Validation error Request failed with status code 500` error when saving a dashboard in DataLens
    • Resolving the `Bad Request for url MetrikaHttpApiException direct_client_logins` error
    • Resolving the `ERR.DS_API.FORMULA.VALIDATION.AGG.INCONSISTENT - Inconsistent aggregation among operands` error
    • Resolving the `ERR.DS_API.US.BAD_REQUEST data.key should not start with /` error
    • Some fields are not displayed in datasets built on Yandex Metrica
    • Resolving the `SSL is required` error
    • Resolving an incorrect `Total` value in a pivot table

In this article:

  • Issue description
  • Solution
  1. DataLens
  2. Resolving the `ERR.DS_API.FORMULA.VALIDATION.AGG.INCONSISTENT - Inconsistent aggregation among operands` error

Fixing the ERR.DS_API.FORMULA.VALIDATION.AGG.INCONSISTENT - Inconsistent aggregation among operands error

Written by
Yandex Cloud
Updated at December 17, 2025
View in Markdown
  • Issue description
  • Solution

Issue descriptionIssue description

When validating a formula, you see this error:

ERR.DS_API.FORMULA.VALIDATION.AGG.INCONSISTENT - Inconsistent aggregation among operands

SolutionSolution

This error occurs when you try to use both aggregated and non-aggregated expressions as arguments of the same function or as operands of the same operator.

Yandex DataLens does not support using aggregated and non-aggregated values in the same expression, so you cannot use measures and dimensions together. The dataset and wizard highlight measures in blue and dimensions in green.

For more details, see this guide.

Note

When validating data and formulas in a dataset, Yandex DataLens may process a large amount of data, so we recommend additionally monitoring the consistency of your data and formulas.

Was the article helpful?

Previous
Resolving the `Bad Request for url MetrikaHttpApiException direct_client_logins` error
Next
Resolving the `ERR.DS_API.US.BAD_REQUEST data.key should not start with /` error
© 2026 Direct Cursus Technology L.L.C.