[Yandex Cloud documentation](../index.md) > Yandex DataLens > DataLens # Yandex DataLens Yandex DataLens is a business analytics tool for visualizing your data. Visualize data from various sources, build dashboards, and generate reports in the form of interactive slide decks. Track critical product and business metrics in real time, share results with your team, and make informed decisions. Use the Neuroanalyst to automatically analyze your data, get insights, create and edit visualizations. # Yandex DataLens ## Getting started - [Overview](concepts/index.md) - [Getting started](quickstart.md) - [Quotas and limits](concepts/limits.md) - [Courses](training.md) ## Workbooks and collections - [Overview](workbooks-collections/index.md) - [Operations with workbooks](workbooks-collections/workbooks-operations.md) - [Operations with collections](workbooks-collections/collections-operations.md) - [Migrating objects to workbooks from directories](workbooks-collections/migrations.md) - [Exporting and importing workbooks](workbooks-collections/export-and-import.md) - [Errors and warnings during export and import](workbooks-collections/export-import-notifications.md) - [DataLens neuroanalyst](concepts/neuroanalyst.md) ## Tutorials - [Overview](tutorials/index.md) ### Getting started with DataLens - [Simple dashboard from a CSV file](tutorials/data-from-csv-visualization.md) - [Public chart with a map of Moscow from a CSV file](tutorials/data-from-csv-to-public-visualization.md) - [Retail chain's dashboard based on a ClickHouse® database](tutorials/data-from-ch-visualization.md) ### Working with geodata - [Analyzing public data on road accidents in Russia](tutorials/data-from-csv-geo-visualization.md) - [Analyzing sales and locations of pizzerias based on data from a ClickHouse® database and the DataLens Gallery](tutorials/data-from-ch-to-geolayers-visualization.md) - [Geocoding with the Yandex Maps API for data visualization in DataLens](tutorials/data-from-ch-geocoder.md) - [Visualizing data using Heat Maps](tutorials/data-on-heat-map-dashboard.md) - [Monitoring the status of geographically distributed devices](tutorials/datalens.md) ### Service analytics - [Yandex Metrica: Direct connection](tutorials/data-from-metrica-visualization.md) - [Yandex Metrica: data export, post-processing, and visualization](tutorials/data-from-metrica-yc-visualization.md) - [AppMetrica: direct connection](tutorials/data-from-appmetrica-visualization.md) - [AppMetrica: data export, post-processing, and visualization](tutorials/data-from-appmetrica-yc-visualization.md) - [Bitrix24: Direct connection](tutorials/data-from-bitrix24-visualization.md) - [Yandex Tracker: Data export and visualization](tutorials/data-from-tracker.md) - [Analyzing Object Storage logs using DataLens](tutorials/storage-logs-analysis.md) - [Yandex Music podcasts: Statistics](tutorials/data-from-podcasts.md) - [Visualizing Yandex Query data](tutorials/data-from-yandex-query-visualization.md) - [Visualizing Yandex Monitoring data](tutorials/data-from-monitoring-visualization.md) - [Visualizing YTsaurus CHYT data](tutorials/data-from-ch-over-yt.md) - [Streaming Yandex Cloud Postbox events to Yandex Data Streams and analyzing them using Yandex DataLens](tutorials/events-from-postbox-to-yds.md) #### Transferring Yandex Forms data to Yandex DataLens via Yandex Cloud Functions and Yandex Query - [Overview](tutorials/forms-and-datalens-integration/index.md) - [Management console](tutorials/forms-and-datalens-integration/console.md) - [Terraform](tutorials/forms-and-datalens-integration/terraform.md) - [Migrating databases from Google BigQuery to Managed Service for ClickHouse®](tutorials/bigquery-to-clickhouse.md) ### Tutorials for features - [Using parameters in calculated fields](tutorials/data-from-ch-with-parameters.md) - [Source parameterization](tutorials/data-from-ch-dataset-parametrization.md) - [Examples of creating QL charts](tutorials/data-from-ch-to-sql-chart.md) - [Examples of charts created in Editor](tutorials/create-chart-editor.md) - [Example of using the Activities tab in Editor](tutorials/create-editor-activities.md) ## Connections - [Overview](concepts/connection/index.md) - [Versioning](concepts/connection/versioning.md) - [Caching](concepts/caching.md) - [Combining data](concepts/data-join.md) - [Adding connection info](operations/connection/add-description.md) ### Databases - [Creating a ClickHouse® connection](operations/connection/create-clickhouse.md) - [Creating a PostgreSQL connection](operations/connection/create-postgresql.md) - [Creating a MySQL® connection](operations/connection/create-mysql.md) - [Creating a YDB connection](operations/connection/create-ydb.md) #### Creating a YTsaurus CHYT connection - [Connection](operations/connection/chyt/create-chyt.md) - [Features of JOIN](operations/connection/chyt/chyt-global-join.md) - [Recommendations](operations/connection/chyt/chyt-recommendations.md) - [Creating a Greenplum® connection](operations/connection/create-greenplum.md) - [Creating a SQL Server connection](operations/connection/create-mssql-server.md) - [Creating an Oracle Database connection](operations/connection/create-oracle.md) - [Creating a StarRocks connection](operations/connection/create-starrocks.md) - [Creating a Prometheus connection](operations/connection/create-prometheus.md) - [Creating a Snowflake connection](operations/connection/create-snowflake.md) - [Creating a Trino connection](operations/connection/create-trino.md) ### Files and services - [Creating a connection to files](operations/connection/create-file.md) - [Creating a connection to Yandex Documents](operations/connection/create-yadocs.md) - [Creating a Google Sheets connection](operations/connection/create-google-sheets.md) - [Creating a Yandex Query connection](operations/connection/create-yandex-query.md) - [Creating a Yandex Metrica API connection](operations/connection/create-metrica-api.md) - [Creating an AppMetrica connection](operations/connection/create-appmetrica.md) - [Creating a Yandex Cloud Billing connection](operations/connection/create-cloud-billing.md) - [Creating a Yandex Monitoring connection](operations/connection/create-monitoring.md) #### Creating a connection to DataLens Usage Analytics - [Overview](concepts/datalens-usage-analytics.md) - [Connection](operations/connection/create-usage-tracking.md) - [Creating an API Connector connection](operations/connection/create-api-connector.md) - [Creating a SpeechSense connection](operations/connection/create-speechsense.md) ### Partner connections - [Creating a connection to 1C Extractor](operations/connection/create-extractor1c.md) - [Creating a Bitrix24 connection](operations/connection/create-bitrix24.md) - [Creating a connection to Yandex Music podcasts](operations/connection/create-podcasts.md) - [Offering a custom partner connector](operations/marketplace/create-connector-for-partners.md) ## Datasets - [Overview](dataset/index.md) - [Working with datasets](dataset/create-dataset.md) - [Data model](dataset/data-model.md) - [Dataset settings](dataset/settings.md) - [Versioning](dataset/versioning.md) - [Adding dataset info](dataset/add-description.md) - [Source parameterization](dataset/parametrization.md) - [Cache invalidation](dataset/cache-invalidation.md) - [Data types](dataset/data-types.md) - [Data type mapping](dataset/types-lookup-table.md) ## Calculated fields - [Overview](concepts/calculations/index.md) - [Formula syntax](concepts/calculations/formula-syntax.md) - [Neuroanalyst for creating calculated fields](concepts/calculations/formulas-helper.md) ### Function reference - [All Functions](function-ref/all.md) #### Aggregate functions - [Overview](function-ref/aggregation-functions.md) - [ALL_CONCAT](function-ref/ALL_CONCAT.md) - [ANY](function-ref/ANY.md) - [ARG_MAX](function-ref/ARG_MAX.md) - [ARG_MIN](function-ref/ARG_MIN.md) - [AVG](function-ref/AVG.md) - [AVG_IF](function-ref/AVG_IF.md) - [COUNT](function-ref/COUNT.md) - [COUNTD](function-ref/COUNTD.md) - [COUNTD_APPROX](function-ref/COUNTD_APPROX.md) - [COUNTD_IF](function-ref/COUNTD_IF.md) - [COUNT_IF](function-ref/COUNT_IF.md) - [MAX](function-ref/MAX.md) - [MEDIAN](function-ref/MEDIAN.md) - [MIN](function-ref/MIN.md) - [QUANTILE](function-ref/QUANTILE.md) - [QUANTILE_APPROX](function-ref/QUANTILE_APPROX.md) - [STDEV](function-ref/STDEV.md) - [STDEVP](function-ref/STDEVP.md) - [SUM](function-ref/SUM.md) - [SUM_IF](function-ref/SUM_IF.md) - [TOP_CONCAT](function-ref/TOP_CONCAT.md) - [VAR](function-ref/VAR.md) - [VARP](function-ref/VARP.md) #### Array functions - [Overview](function-ref/array-functions.md) - [ARRAY](function-ref/ARRAY.md) - [ARR_AVG](function-ref/ARR_AVG.md) - [ARR_DISTINCT](function-ref/ARR_DISTINCT.md) - [ARR_INDEX_OF](function-ref/ARR_INDEX_OF.md) - [ARR_INTERSECT](function-ref/ARR_INTERSECT.md) - [ARR_MAX](function-ref/ARR_MAX.md) - [ARR_MIN](function-ref/ARR_MIN.md) - [ARR_PRODUCT](function-ref/ARR_PRODUCT.md) - [ARR_REMOVE](function-ref/ARR_REMOVE.md) - [ARR_STR](function-ref/ARR_STR.md) - [ARR_SUM](function-ref/ARR_SUM.md) - [CAST_ARR_FLOAT](function-ref/CAST_ARR_FLOAT.md) - [CAST_ARR_INT](function-ref/CAST_ARR_INT.md) - [CAST_ARR_STR](function-ref/CAST_ARR_STR.md) - [CONTAINS](function-ref/CONTAINS_ARRAY.md) - [CONTAINS_ALL](function-ref/CONTAINS_ALL.md) - [CONTAINS_ANY](function-ref/CONTAINS_ANY.md) - [CONTAINS_SUBSEQUENCE](function-ref/CONTAINS_SUBSEQUENCE.md) - [COUNT_ITEM](function-ref/COUNT_ITEM.md) - [GET_ITEM](function-ref/GET_ITEM.md) - [LEN](function-ref/LEN_ARRAY.md) - [REPLACE](function-ref/REPLACE_ARRAY.md) - [SLICE](function-ref/SLICE.md) - [STARTSWITH](function-ref/STARTSWITH_ARRAY.md) - [UNNEST](function-ref/UNNEST.md) #### Date/Time functions - [Overview](function-ref/date-functions.md) - [DATEADD](function-ref/DATEADD.md) - [DATEPART](function-ref/DATEPART.md) - [DATETRUNC](function-ref/DATETRUNC.md) - [DAY](function-ref/DAY.md) - [DAYOFWEEK](function-ref/DAYOFWEEK.md) - [HOUR](function-ref/HOUR.md) - [MINUTE](function-ref/MINUTE.md) - [MONTH](function-ref/MONTH.md) - [NOW](function-ref/NOW.md) - [QUARTER](function-ref/QUARTER.md) - [SECOND](function-ref/SECOND.md) - [TODAY](function-ref/TODAY.md) - [WEEK](function-ref/WEEK.md) - [YEAR](function-ref/YEAR.md) #### Hash functions - [Overview](function-ref/hash-functions.md) - [CITYHASH64](function-ref/CITYHASH64.md) - [INTHASH64](function-ref/INTHASH64.md) - [MD5](function-ref/MD5.md) - [MURMURHASH2_64](function-ref/MURMURHASH2_64.md) - [SHA1](function-ref/SHA1.md) - [SHA256](function-ref/SHA256.md) - [SIPHASH64](function-ref/SIPHASH64.md) #### Logical functions - [Overview](function-ref/logical-functions.md) - [CASE](function-ref/CASE.md) - [IF](function-ref/IF.md) - [IFNULL](function-ref/IFNULL.md) - [ISNULL](function-ref/ISNULL.md) - [ZN](function-ref/ZN.md) #### Mathematical functions - [Overview](function-ref/numeric-functions.md) - [ABS](function-ref/ABS.md) - [ACOS](function-ref/ACOS.md) - [ASIN](function-ref/ASIN.md) - [ATAN](function-ref/ATAN.md) - [ATAN2](function-ref/ATAN2.md) - [CEILING](function-ref/CEILING.md) - [COMPARE](function-ref/COMPARE.md) - [COS](function-ref/COS.md) - [COT](function-ref/COT.md) - [DEGREES](function-ref/DEGREES.md) - [DIV](function-ref/DIV.md) - [DIV_SAFE](function-ref/DIV_SAFE.md) - [EXP](function-ref/EXP.md) - [FDIV_SAFE](function-ref/FDIV_SAFE.md) - [FLOOR](function-ref/FLOOR.md) - [GREATEST](function-ref/GREATEST.md) - [LEAST](function-ref/LEAST.md) - [LN](function-ref/LN.md) - [LOG](function-ref/LOG.md) - [LOG10](function-ref/LOG10.md) - [PI](function-ref/PI.md) - [POWER](function-ref/POWER.md) - [RADIANS](function-ref/RADIANS.md) - [ROUND](function-ref/ROUND.md) - [SIGN](function-ref/SIGN.md) - [SIN](function-ref/SIN.md) - [SQRT](function-ref/SQRT.md) - [SQUARE](function-ref/SQUARE.md) - [TAN](function-ref/TAN.md) #### Native functions - [Overview](function-ref/native-functions.md) - [DB_CALL_AGG_FLOAT](function-ref/DB_CALL_AGG_FLOAT.md) - [DB_CALL_AGG_INT](function-ref/DB_CALL_AGG_INT.md) - [DB_CALL_AGG_STRING](function-ref/DB_CALL_AGG_STRING.md) - [DB_CALL_ARRAY_FLOAT](function-ref/DB_CALL_ARRAY_FLOAT.md) - [DB_CALL_ARRAY_INT](function-ref/DB_CALL_ARRAY_INT.md) - [DB_CALL_ARRAY_STRING](function-ref/DB_CALL_ARRAY_STRING.md) - [DB_CALL_BOOL](function-ref/DB_CALL_BOOL.md) - [DB_CALL_FLOAT](function-ref/DB_CALL_FLOAT.md) - [DB_CALL_INT](function-ref/DB_CALL_INT.md) - [DB_CALL_STRING](function-ref/DB_CALL_STRING.md) #### Operators - [Overview](function-ref/operator-functions.md) - [AND](function-ref/AND.md) - [Addition and concatenation (+)](function-ref/OP_PLUS.md) - [BETWEEN](function-ref/BETWEEN.md) - [Comparison](function-ref/OP_COMPARISON.md) - [Division (/)](function-ref/OP_DIV.md) - [IN](function-ref/IN.md) - [IS FALSE](function-ref/ISFALSE.md) - [IS TRUE](function-ref/ISTRUE.md) - [LIKE](function-ref/LIKE.md) - [Modulo (%)](function-ref/OP_MOD.md) - [Multiplication (*)](function-ref/OP_MULT.md) - [NOT](function-ref/OP_NOT.md) - [Negation (-)](function-ref/OP_NEGATION.md) - [OR](function-ref/OR.md) - [Power (^)](function-ref/OP_POWER.md) - [Subtraction (-)](function-ref/OP_MINUS.md) #### String functions - [Overview](function-ref/string-functions.md) - [ASCII](function-ref/ASCII.md) - [CHAR](function-ref/CHAR.md) - [CONCAT](function-ref/CONCAT.md) - [CONTAINS](function-ref/CONTAINS.md) - [ENDSWITH](function-ref/ENDSWITH.md) - [FIND](function-ref/FIND.md) - [ICONTAINS](function-ref/ICONTAINS.md) - [IENDSWITH](function-ref/IENDSWITH.md) - [ISTARTSWITH](function-ref/ISTARTSWITH.md) - [LEFT](function-ref/LEFT.md) - [LEN](function-ref/LEN.md) - [LOWER](function-ref/LOWER.md) - [LTRIM](function-ref/LTRIM.md) - [REGEXP_EXTRACT](function-ref/REGEXP_EXTRACT.md) - [REGEXP_EXTRACT_ALL](function-ref/REGEXP_EXTRACT_ALL.md) - [REGEXP_EXTRACT_NTH](function-ref/REGEXP_EXTRACT_NTH.md) - [REGEXP_MATCH](function-ref/REGEXP_MATCH.md) - [REGEXP_REPLACE](function-ref/REGEXP_REPLACE.md) - [REPLACE](function-ref/REPLACE.md) - [RIGHT](function-ref/RIGHT.md) - [RTRIM](function-ref/RTRIM.md) - [SPACE](function-ref/SPACE.md) - [SPLIT](function-ref/SPLIT.md) - [STARTSWITH](function-ref/STARTSWITH.md) - [SUBSTR](function-ref/SUBSTR.md) - [TRIM](function-ref/TRIM.md) - [UPPER](function-ref/UPPER.md) - [UTF8](function-ref/UTF8.md) #### Text markup functions - [Overview](function-ref/markup-functions.md) - [BOLD](function-ref/BOLD.md) - [BR](function-ref/BR.md) - [COLOR](function-ref/COLOR.md) - [IMAGE](function-ref/IMAGE.md) - [ITALIC](function-ref/ITALIC.md) - [MARKUP](function-ref/MARKUP.md) - [SIZE](function-ref/SIZE.md) - [TOOLTIP](function-ref/TOOLTIP.md) - [URL](function-ref/URL.md) - [USER_INFO](function-ref/USER_INFO.md) #### Time series functions - [Overview](function-ref/time-series-functions.md) - [AGO](function-ref/AGO.md) - [AT_DATE](function-ref/AT_DATE.md) #### Type conversion functions - [Overview](function-ref/type-conversion-functions.md) - [BOOL](function-ref/BOOL.md) - [DATE](function-ref/DATE.md) - [DATETIME](function-ref/DATETIME.md) - [DATETIME_PARSE](function-ref/DATETIME_PARSE.md) - [DATE_PARSE](function-ref/DATE_PARSE.md) - [DB_CAST](function-ref/DB_CAST.md) - [FLOAT](function-ref/FLOAT.md) - [GEOPOINT](function-ref/GEOPOINT.md) - [GEOPOLYGON](function-ref/GEOPOLYGON.md) - [INT](function-ref/INT.md) - [STR](function-ref/STR.md) - [TREE](function-ref/TREE.md) #### Window functions - [Overview](function-ref/window-functions.md) - [AVG](function-ref/AVG_WINDOW.md) - [AVG_IF](function-ref/AVG_IF_WINDOW.md) - [COUNT](function-ref/COUNT_WINDOW.md) - [COUNT_IF](function-ref/COUNT_IF_WINDOW.md) - [FIRST](function-ref/FIRST.md) - [LAG](function-ref/LAG.md) - [LAST](function-ref/LAST.md) - [MAVG](function-ref/MAVG.md) - [MAX](function-ref/MAX_WINDOW.md) - [MCOUNT](function-ref/MCOUNT.md) - [MIN](function-ref/MIN_WINDOW.md) - [MMAX](function-ref/MMAX.md) - [MMIN](function-ref/MMIN.md) - [MSUM](function-ref/MSUM.md) - [RANK](function-ref/RANK.md) - [RANK_DENSE](function-ref/RANK_DENSE.md) - [RANK_PERCENTILE](function-ref/RANK_PERCENTILE.md) - [RANK_UNIQUE](function-ref/RANK_UNIQUE.md) - [RAVG](function-ref/RAVG.md) - [RCOUNT](function-ref/RCOUNT.md) - [RMAX](function-ref/RMAX.md) - [RMIN](function-ref/RMIN.md) - [RSUM](function-ref/RSUM.md) - [SUM](function-ref/SUM_WINDOW.md) - [SUM_IF](function-ref/SUM_IF_WINDOW.md) - [Function Availability](function-ref/availability.md) ### Examples of using functions - [Aggregation functions](concepts/aggregation-tutorial.md) - [Window functions](concepts/window-function-tutorial.md) - [LOD expressions and filtering management in aggregation functions](concepts/lod-aggregation.md) - [Functions for time series](concepts/time-series-functions.md) - [Parameters](concepts/parameters.md) ## Charts - [Overview](concepts/chart/index.md) ### Wizard charts - [Overview](concepts/chart/dataset-based-charts.md) - [Chart settings](concepts/chart/settings.md) - [Measure Values and Measure Names](concepts/chart/measure-values.md) - [Multi-dataset charts](concepts/chart/multidataset-chart.md) #### Step-by-step guides - [Creating a chart](operations/chart/create-chart.md) - [Replacing a dataset in a chart](operations/chart/replace-dataset.md) - [Creating a multi-dataset chart](operations/chart/create-multidataset-chart.md) - [Adding a hierarchy](operations/chart/add-hierarchy.md) - [Configuring a navigator](operations/chart/config-chart-navigator.md) - [Configuring the display of null values](operations/chart/chart-null-settings.md) - [Configuring a color palette](operations/chart/create-palette.md) ### QL charts - [Overview](concepts/chart/ql-charts.md) - [Creating a QL chart](operations/chart/create-sql-chart.md) ### Charts in Editor - [Overview](charts/editor/index.md) #### Quick start in Editor - [Overview](charts/editor/quickstart/index.md) - [Creating a table based on a dataset](charts/editor/quickstart/from-dataset.md) - [Creating a table based on an SQL query](charts/editor/quickstart/from-database.md) - [Creating a table via API](charts/editor/quickstart/from-api-connector.md) - [Neuroanalyst in Editor](charts/editor/code-helper.md) - [Tabs](charts/editor/tabs.md) - [Sources](charts/editor/sources.md) - [Available methods](charts/editor/methods.md) - [Notifications](charts/editor/notifications.md) - [Chart links in dashboards and reports](charts/editor/links.md) - [Cross-filtering](charts/editor/cross-filtration.md) - [Chart debugging](charts/editor/debug.md) #### Visualization types - [Overview](charts/editor/widgets/index.md) - [Table](charts/editor/widgets/table.md) - [Chart (Gravity UI Charts)](charts/editor/widgets/gravity-ui.md) - [Markdown](charts/editor/widgets/markdown.md) - [Advanced chart](charts/editor/widgets/advanced.md) - [Selector](charts/editor/widgets/controls.md) ### Visualization reference - [All visualizations](visualization-ref/index.md) - [Line chart](visualization-ref/line-chart.md) - [Area chart](visualization-ref/area-chart.md) - [Normalized stacked area chart](visualization-ref/normalized-area-chart.md) - [Column chart](visualization-ref/column-chart.md) - [Normalized column chart](visualization-ref/normalized-column-chart.md) - [Bar chart](visualization-ref/bar-chart.md) - [Normalized bar chart](visualization-ref/normalized-bar-chart.md) - [Scatter chart](visualization-ref/scatter-chart.md) - [Pie chart](visualization-ref/pie-chart.md) - [Combined chart](visualization-ref/combined-chart.md) - [Tree chart](visualization-ref/tree-chart.md) - [Donut chart](visualization-ref/ring-chart.md) - [Table](visualization-ref/table-chart.md) - [Pivot table](visualization-ref/pivot-table-chart.md) - [Indicator](visualization-ref/indicator-chart.md) #### Map - [Overview](visualization-ref/map-chart.md) - [Point map](visualization-ref/point-map-chart.md) - [Point map with clusters](visualization-ref/cluster-point-map-chart.md) - [Polyline map](visualization-ref/polyline-map-chart.md) - [Choropleth map](visualization-ref/choropleth-map-chart.md) - [Heat map](visualization-ref/heat-map-chart.md) ### Chart parameters - [Adding parameters in dashboard chart settings](operations/chart/add-parameters.md) - [Adding an ID as a parameter](operations/chart/add-guid.md) - [Adding parameters to a chart](operations/chart/add-parameter-chart.md) - [Adding chart info](operations/chart/add-description.md) - [Opening a chart as a table](operations/chart/open-as-table.md) - [Saving a chart as an image](operations/chart/save-as-image.md) - [Versioning](concepts/chart/versioning.md) - [Exporting data from charts](concepts/chart/data-export.md) - [Chart inspector](concepts/chart/inspector.md) - [Access management](concepts/chart/access-management.md) ## Dashboards - [Overview](concepts/dashboard.md) - [Widgets](dashboard/widget.md) - [Link](dashboard/link.md) - [Selectors](dashboard/selector.md) - [Cross-chart filtering](dashboard/chart-chart-filtration.md) - [Dashboard settings](dashboard/settings.md) - [Mailing lists](operations/dashboard/add-maillists.md) - [Versioning](dashboard/versioning.md) - [Parameters](dashboard/dashboard_parameters.md) - [Neuroanalyst on your dashboard](dashboard/insights.md) - [Trend and smoothing lines in dashboard charts](dashboard/trends-and-smoothing.md) - [Markdown](dashboard/markdown.md) ### Step-by-step guides - [Creating a dashboard](operations/dashboard/create.md) #### Dashboard widgets - [Adding a chart to a dashboard](operations/dashboard/add-chart.md) - [Adding a selector to a dashboard](operations/dashboard/add-selector.md) - [Adding text to a dashboard](operations/dashboard/add-text.md) - [Adding a header to a dashboard](operations/dashboard/add-title.md) - [Adding a JS selector to a dashboard](charts/editor/add-js-selector.md) - [Adding an insight widget to a dashboard](operations/dashboard/add-ai.md) - [Copying widgets on a dashboard](operations/dashboard/copying-widgets.md) - [Adding dashboard info](operations/dashboard/add-description.md) #### Dashboard settings - [Changing dashboard settings](operations/dashboard/dash-settings.md) - [Adding a message displayed when contacting support](operations/dashboard/add-support-message.md) - [Adding an access error message](operations/dashboard/add-access-message.md) - [Adding parameters to a dashboard](operations/dashboard/add-parameters.md) - [Dashboard auto-update](operations/dashboard/auto-update.md) - [Banning Neuroanalyst on the dashboard](operations/dashboard/dashboard-neuroanalyst-off.md) #### Link settings - [Configuring links on the dashboard](operations/dashboard/dashboard-links.md) - [Creating an alias](operations/dashboard/create-alias.md) - [Deleting an alias](operations/dashboard/edit-alias.md) #### Appearance customization options - [Configuring dashboard background](operations/dashboard/add-dashboard-background.md) - [Configuring the background and opacity of dashboard widgets](operations/dashboard/add-widget-background.md) - [Configuring corner rounding on a dashboard](operations/dashboard/add-rounding.md) - [Configuring offsets on the dashboard](operations/dashboard/add-margins.md) - [Configuring the dashboard title](operations/dashboard/add-title-dashboard.md) - [Adding a table of contents to the dashboard](operations/dashboard/add-contents.md) #### Managing dashboard tabs - [Configuring dashboard tabs](operations/dashboard/dashboard-tabs.md) - [Customizing tab display](operations/dashboard/dashboard-hide-tabs.md) - [Reference tab for AI](operations/dashboard/dashboard-ai-reference-tab.md) - [Widget display order on a mobile device](operations/dashboard/display-modes.md) - [Setting up cross-chart filtering](operations/dashboard/add-filtration.md) - [Managing access to a dashboard](operations/dashboard/manage-access.md) ## Reports - [Overview](reports/index.md) - [Working with reports](reports/report-operations.md) - [Selectors in reports](reports/add-selector.md) - [Versioning](reports/versioning.md) - [Neuroanalyst in reports](reports/insights.md) ## Publishing and embedding - [Overview](concepts/publishing-and-embedding.md) - [Publishing objects](concepts/datalens-public.md) - [Public embedding](security/embedded-objects.md) - [Sharing an object within an organization](concepts/datalens-sharing.md) - [Embedding via JWT](security/private-embedded-objects.md) ## Access management - [Overview](security/index.md) - [DataLens roles](security/roles.md) ### Organizations in DataLens - [Overview](concepts/organizations.md) - [Switching between DataLens instances](operations/organizations/change-organization.md) ### Access to objects in workbooks and collections - [Overview](security/workbooks-access.md) - [Basic setup](security/workbooks-access-basic.md) - [Advanced setup (shared objects)](security/workbooks-access-advanced.md) ### Access to objects in directories - [Access permissions](security/manage-access.md) - [Assigning and changing access permissions](operations/permission/grant.md) - [Deleting access permissions](operations/permission/revoke.md) - [Requesting access permissions](operations/permission/request.md) - [Access to data rows](security/row-level-security.md) ## Service settings - [Overview](settings/index.md) - [Seats](settings/seats.md) - [Users](security/add-new-user.md) - [Service plans and payment](settings/service-plan.md) - [Appearance](settings/appearance.md) - [Security](settings/restrictions.md) - [Navigation](settings/navigation.md) - [Gallery in DataLens](concepts/gallery.md) ## Pricing policy - [Current pricing policy](pricing.md) ### Archive - [Pricing policy updates as of December 1](pricing-changes.md) - [Pricing policy before December 1, 2025](pricing-old.md) - [Service plans before December 1, 2025](concepts/service-plans-comparison.md) ## DataLens Public API - [How to use the Public API](operations/api-start.md) ### DataLens API - [Overview](openapi-ref/index.md) - [createCollection](openapi-ref/createCollection.md) - [deleteCollection](openapi-ref/deleteCollection.md) - [deleteCollections](openapi-ref/deleteCollections.md) - [getCollectionBreadcrumbs](openapi-ref/getCollectionBreadcrumbs.md) - [getCollection](openapi-ref/getCollection.md) - [getCollectionContent](openapi-ref/getCollectionContent.md) - [getRootCollectionPermissions](openapi-ref/getRootCollectionPermissions.md) - [moveCollection](openapi-ref/moveCollection.md) - [moveCollections](openapi-ref/moveCollections.md) - [updateCollection](openapi-ref/updateCollection.md) - [getConnection](openapi-ref/getConnection.md) - [createConnection](openapi-ref/createConnection.md) - [updateConnection](openapi-ref/updateConnection.md) - [deleteConnection](openapi-ref/deleteConnection.md) - [getDashboard](openapi-ref/getDashboard.md) - [createDashboard](openapi-ref/createDashboard.md) - [updateDashboard](openapi-ref/updateDashboard.md) - [deleteDashboard](openapi-ref/deleteDashboard.md) - [getDataset](openapi-ref/getDataset.md) - [createDataset](openapi-ref/createDataset.md) - [updateDataset](openapi-ref/updateDataset.md) - [deleteDataset](openapi-ref/deleteDataset.md) - [validateDataset](openapi-ref/validateDataset.md) - [getEntriesRelations](openapi-ref/getEntriesRelations.md) - [getEntries](openapi-ref/getEntries.md) - [getQLChart](openapi-ref/getQlChart.md) - [deleteQLChart](openapi-ref/deleteQlChart.md) - [updateQLChart](openapi-ref/updateQlChart.md) - [createQLChart](openapi-ref/createQlChart.md) - [getWizardChart](openapi-ref/getWizardChart.md) - [deleteWizardChart](openapi-ref/deleteWizardChart.md) - [updateWizardChart](openapi-ref/updateWizardChart.md) - [createWizardChart](openapi-ref/createWizardChart.md) - [createWorkbook](openapi-ref/createWorkbook.md) - [deleteWorkbook](openapi-ref/deleteWorkbook.md) - [deleteWorkbooks](openapi-ref/deleteWorkbooks.md) - [getWorkbook](openapi-ref/getWorkbook.md) - [getWorkbooksList](openapi-ref/getWorkbooksList.md) - [moveWorkbook](openapi-ref/moveWorkbook.md) - [moveWorkbooks](openapi-ref/moveWorkbooks.md) - [updateWorkbook](openapi-ref/updateWorkbook.md) - [getWorkbookEntries](openapi-ref/getWorkbookEntries.md) - [getEditorChart](openapi-ref/getEditorChart.md) - [deleteEditorChart](openapi-ref/deleteEditorChart.md) - [createEditorChart](openapi-ref/createEditorChart.md) - [updateEditorChart](openapi-ref/updateEditorChart.md) - [createEmbed](openapi-ref/createEmbed.md) - [listEmbeds](openapi-ref/listEmbeds.md) - [deleteEmbed](openapi-ref/deleteEmbed.md) - [updateEmbed](openapi-ref/updateEmbed.md) - [getEntriesPermissions](openapi-ref/getEntriesPermissions.md) - [createEmbeddingSecret](openapi-ref/createEmbeddingSecret.md) - [listEmbeddingSecrets](openapi-ref/listEmbeddingSecrets.md) - [deleteEmbeddingSecret](openapi-ref/deleteEmbeddingSecret.md) - [getEmbeddingSecret](openapi-ref/getEmbeddingSecret.md) - [getAuditEntriesUpdates](openapi-ref/getAuditEntriesUpdates.md) - [updateCollectionAccessBindings](openapi-ref/updateCollectionAccessBindings.md) - [createFolder](openapi-ref/createFolder.md) - [listDirectory](openapi-ref/listDirectory.md) - [updateWorkbookAccessBindings](openapi-ref/updateWorkbookAccessBindings.md) - [Audit Trails events](at-ref.md) ## Release notes - [May 2026](release-notes/index.md) - [April 2026](release-notes/2604.md) - [March 2026](release-notes/2603.md) - [February 2026](release-notes/2602.md) - [January 2026](release-notes/2601.md) - [December 2025](release-notes/2512.md) ### Archive - [November 2025](release-notes/2511.md) - [October 2025](release-notes/2510.md) - [September 2025](release-notes/2509.md) - [August 2025](release-notes/2508.md) - [July 2025](release-notes/2507.md) - [June 2025](release-notes/2506.md) - [May 2025](release-notes/2505.md) - [April 2025](release-notes/2504.md) - [March 2025](release-notes/2503.md) - [February 2025](release-notes/2502.md) - [January 2025](release-notes/2501.md) - [December 2024](release-notes/2412.md) - [November 2024](release-notes/2411.md) - [October 2024](release-notes/2410.md) - [September 2024](release-notes/2409.md) - [August 2024](release-notes/2408.md) - [July 2024](release-notes/2407.md) - [June 2024](release-notes/2406.md) - [May 2024](release-notes/2405.md) - [April 2024](release-notes/2404.md) - [March 2024](release-notes/2403.md) - [February 2024](release-notes/2402.md) - [January 2024](release-notes/2401.md) ## Troubleshooting - [Optimization best practices](concepts/optimization_recommendations.md) - [Errors DataLens](troubleshooting/errors/all.md) ### FAQ - [All questions](qa/index.md) - [Users and access management](qa/permissions.md) - [Billing and payment](qa/pricing.md) - [Connections](qa/connections.md) - [Datasets](qa/datasets.md) - [Charts](qa/charts.md) - [Calculated fields](qa/calculation-fields.md) - [Dashboards](qa/dashboards.md) - [Workbooks and collections](qa/workbooks-collections.md) - [Reports](qa/reports.md) - [Private embedding](qa/embedded.md) - [Other](qa/other.md) - [Access denied](troubleshooting/errors/ERR-DS_API-US-ACCESS_DENIED.md) - [Access to table was denied](troubleshooting/errors/ERR-DS_API-DB-CHYT-TABLE_ACCESS_DENIED.md) - [Authentication failed](troubleshooting/errors/ERR-DS_API-DB-CHYT-AUTH_FAILED.md) - [Backend app request timeout exceeded](troubleshooting/errors/ERR-DS_API-REQUEST_TIMEOUT.md) - [Blocks have different column count](troubleshooting/errors/ERR-DS_API-BLOCK-UNEVEN_COLUMN_COUNT.md) - [Cannot join a concatenation of tables with another table](troubleshooting/errors/ERR-DS_API-DB-CHYT-INVALID_SORTED_JOIN-MORE_THAN_ONE_TABLE.md) - [Cannot parse](troubleshooting/errors/ERR-DS_API-DB-CANNOT_PARSE.md) - [Cannot parse datetime](troubleshooting/errors/ERR-DS_API-DB-CANNOT_PARSE-DATETIME.md) - [Cannot parse number](troubleshooting/errors/ERR-DS_API-DB-CANNOT_PARSE-NUMBER.md) - [Column used in join expression is not a key column](troubleshooting/errors/ERR-DS_API-DB-CHYT-INVALID_SORTED_JOIN-NOT_A_KEY_COLUMN.md) - [ROUND with precision parameter is not supported for double precision data type in PostgreSQL](troubleshooting/errors/ERR-DS_API-DB-INVALID_FUNCTION-PG_DOUBLE_PRECISION_ROUND.md) - [Columns in JOIN have different types](troubleshooting/errors/ERR-DS_API-DB-JOIN_COLUMN_TYPE_MISMATCH.md) - [Data source is unavailable](troubleshooting/errors/ERR-DS_API-DATABASE_UNAVAILABLE.md) - [Data source (table) does not exist](troubleshooting/errors/ERR-DS_API-DB-SOURCE_DOES_NOT_EXIST.md) - [Data source refused connection](troubleshooting/errors/ERR-DS_API-DB-SOURCE_CONNECT_ERROR.md) - [Data source timed out](troubleshooting/errors/ERR-DS_API-DB-SOURCE_ERROR-TIMEOUT.md) - [Database authentication failed](troubleshooting/errors/ERR-DS_API-DB-AUTHENTICATION_FAILED.md) - [Division by zero](troubleshooting/errors/ERR-DS_API-DB-ZERO_DIVISION.md) - [Field title conflicts with another field](troubleshooting/errors/ERR-DS_API-FIELD-TITLE-CONFLICT.md) - [File check failed](troubleshooting/errors/ERR-FILE-UNSUPPORTED_DOCUMENT.md) - [Incorrect Yandex Documents link format](troubleshooting/errors/ERR-FILE-INVALID_LINK-YADOCS_INVALID_PUBLIC_LINK_PREFIX.md) - [Incompatible dimensions](troubleshooting/errors/ERR-DS_API-FORMULA-VALIDATION-LOD-INCOMPATIBLE_DIMENSIONS.md) - [Inconsistent aggregation among operands](troubleshooting/errors/ERR-DS_API-FORMULA-VALIDATION-AGG-INCONSISTENT.md) - [Inconsistent aggregation status among SELECT items](troubleshooting/errors/ERR-DS_API-INVALID_QUERY_STRUCTURE-INCONSISTENT_AGGREGATION.md) - [Data source modification is not allowed](troubleshooting/errors/ERR-DS_API-PREVIEW_SOURCE_MODIFICATION_NOT_ALLOWED.md) - [Internal server error](troubleshooting/errors/ERR-DS_API.md) - [Failed to parse clique name](troubleshooting/errors/ERR-DS_API-DB-CHYT-CLIQUE-INVALID_GUID.md) - [Invalid clique specification. Probably, clique does not exists](troubleshooting/errors/ERR-DS_API-DB-CHYT-CLIQUE-INVALID_SPECIFICATION.md) - [Invalid grouping configuration](troubleshooting/errors/ERR-DS_API-INVALID_GROUP_BY_CONFIGURATION.md) - [Invalid top-level LOD dimension found in expression](troubleshooting/errors/ERR-DS_API-FORMULA-VALIDATION-LOD-INVALID_TOPLEVEL_DIMENSIONS.md) - [Invalid user token](troubleshooting/errors/ERR-DS_API-SOURCE_ACCESS_DENIED-INVALID_TOKEN.md) - [Joined columns should form prefix of joined table key columns](troubleshooting/errors/ERR-DS_API-DB-CHYT-INVALID_SORTED_JOIN-NOT_KEY_PREFIX_COLUMN.md) - [Measure filter is unsupported for this type of query](troubleshooting/errors/ERR-DS_API-FILTER-MEASURE_UNSUPPORTED.md) - [Data preparation not finished](troubleshooting/errors/ERR-DS_API-DB-MATERIALIZATION_NOT_FINISHED.md) - [Memory limit has been exceeded during query execution](troubleshooting/errors/ERR-DS_API-DB-MEMORY_LIMIT_EXCEEDED.md) - [Received too many result data rows](troubleshooting/errors/ERR-DS_API-ROW_COUNT_LIMIT.md) - [Referenced connection cannot be loaded access denied](troubleshooting/errors/ERR-DS_API-REFERENCED_ENTRY_ACCESS_DENIED.md) - [Request size limit exceeded](troubleshooting/errors/ERR-CHARTS-REQUEST_SIZE_LIMIT_EXCEEDED.md) - [Response processing timeout](troubleshooting/errors/ERR-CHARTS-RUNTIME_TIMEOUT.md) - [Requested database column does not exist](troubleshooting/errors/ERR-DS_API-DB-COLUMN_DOES_NOT_EXIST.md) - [Data preparation not finished](troubleshooting/errors/ERR-DS_API-DB-DATA_PREPARATION_NOT_FINISHED.md) - [Subquery exceeds data weight limit](troubleshooting/errors/ERR-DS_API-DB-CHYT-SUBQ_WEIGHT_LIMIT_EXCEEDED.md) - [Use of QL charts is prohibited at connection level](troubleshooting/errors/ERR-DS_API-CONNECTION_CONFIG-DASHSQL_NOT_ALLOWED.md) - [Subquery source is disallowed in the connection settings](troubleshooting/errors/ERR-DS_API-CONNECTION_CONFIG-SUBSELECT_NOT_ALLOWED.md) - [Table configuration is disrupted](troubleshooting/errors/ERR-DS_API-SOURCE_CONFIG-TABLE_NOT_CONFIGURED.md) - [Empty document](troubleshooting/errors/ERR-DS_API-SOURCE-FILE-NO_DATA.md) - [Too many series on the chart](troubleshooting/errors/ERR-CK_TOO_MANY_LINES.md) - [Unknown field](troubleshooting/errors/ERR-DS_API-FIELD-NOT_FOUND.md) - [Unknown field found in formula](troubleshooting/errors/ERR-DS_API-FORMULA-UNKNOWN_FIELD_IN_FORMULA.md) - [Unknown referenced source column](troubleshooting/errors/ERR-DS_API-FORMULA-UNKNOWN_SOURCE_COLUMN.md) - [Unknown dimension for window](troubleshooting/errors/ERR-DS_API-FORMULA-UNKNOWN_WINDOW_DIMENSION.md) - [Window function has unselected dimension](troubleshooting/errors/ERR-DS_API-FORMULA-VALIDATION-WIN_FUNC-BFB_UNSELECTED_DIMENSION.md) - [Window function has no aggregated expressions among its arguments](troubleshooting/errors/ERR-DS_API-FORMULA-VALIDATION-WIN_FUNC-NO_AGG.md) - [YT table has no schema. Only schematized tables are supported](troubleshooting/errors/ERR-DS_API-DB-CHYT-TABLE_HAS_NO_SCHEMA.md) - [Failed to create ](troubleshooting/errors/ERR-DS_API-DB-DB_OPERATIONAL_ERROR.md) - [Invalid file format](troubleshooting/errors/ERR-FILE-PARSE_FAILED-INVALID_EXCEL.md) - [Cannot update data](troubleshooting/errors/ERR-FILE-CANNOT_UPDATE_DATA.md) - [Object request error](troubleshooting/errors/ERR-DS_API-US-BAD_REQUEST.md) - [Error executing a query in the data source](troubleshooting/errors/ERR-DS_API-DB.md) - [Database-side error](troubleshooting/errors/ERR-US-BAD_REQUEST-ALREADY_EXISTS.md) - [Access to the connection was denied](troubleshooting/errors/ERR-DS_API-US-ACCESS_DENIED-CONNECTION.md) - [Connection not found](troubleshooting/errors/ERR-DS_API-US-OBJ_NOT_FOUND-CONNECTION.md) - [Invalid input data: validation failed](troubleshooting/errors/ERR-DS_API-US-VALIDATION_FAILED.md) - [Invalid connection ID](troubleshooting/errors/ERR-DS_API-US-VALIDATION_FAILED-CONNECTION.md) - [Error handling the response](troubleshooting/errors/SDK_REQUEST_ERROR.md) - [Formula syntax error](troubleshooting/errors/ERR-DS_API-FORMULA-PARSE-UNEXPECTED_TOKEN.md) - [Data type conversion error](troubleshooting/errors/ERR-DS_API-TYPE_CAST-FAILED.md) - [Accessing a nonexistent object](troubleshooting/errors/ERR-DS_API-REFERENCED_ENTRY_NOT_FOUND.md) - [Got an unexpected response from an external API](troubleshooting/errors/ERR-AUTH_API-UNEXPECTED_RESPONSE.md) - [Internal Server Error](troubleshooting/errors/ERR-DS_API-ACTION_NOT_ALLOWED.md) - [Field references an unknown source avatar](troubleshooting/errors/ERR-DS_API-AVATAR-NOT_FOUND-FIELD_REF.md) - [Source avatar not found](troubleshooting/errors/ERR-DS_API-AVATAR-NOT_FOUND.md) - [Source avatar title conflicts with another avatar](troubleshooting/errors/ERR-DS_API-AVATAR-TITLE-CONFLICT.md) - [Invalid connection type value](troubleshooting/errors/ERR-DS_API-BAD_CONN_TYPE.md) - [Got items with incompatible roles in block](troubleshooting/errors/ERR-DS_API-BLOCK-ITEM_COMPATIBILITY.md) - [Got more than one block with root placement](troubleshooting/errors/ERR-DS_API-BLOCK-MULTIPLE_ROOTS.md) - [This API does not support multiple query blocks](troubleshooting/errors/ERR-DS_API-BLOCK-MULTIPLE_UNSUPPORTED.md) - [Got no blocks with root placement](troubleshooting/errors/ERR-DS_API-BLOCK-NO_ROOT.md) - [Failed to load description of table columns](troubleshooting/errors/ERR-DS_API-COLUMN_SCHEMA_FAILED.md) - [Internal server error](troubleshooting/errors/ERR-DS_API-CONNECTION_CONFIG.md) - [Internal server error](troubleshooting/errors/ERR-DS_API-DASHSQL-PARAMETER.md) - [Internal server error](troubleshooting/errors/ERR-DS_API-DASHSQL.md) - [There are too many fields in the dataset](troubleshooting/errors/ERR-DS_API-DATASET-TOO_MANY_FIELDS.md) - [Dataset version mismatch. Refresh the page to continue](troubleshooting/errors/ERR-DS_API-DATASET_REVISION_MISMATCH.md) - [Pop-up blocking error](troubleshooting/errors/ERR-CLIENT-POPUP_BLOCKED.md)