Yandex.Cloud
  • Services
  • Why Yandex.Cloud
  • Pricing
  • Documentation
  • Contact us
Get started
Yandex DataLens
  • Getting started
  • Use cases
    • All use cases
    • Visualizing data from a CSV file
    • Visualizing data from a ClickHouse database
    • Visualizing data from Yandex.Metriсa
    • Visualizing data from Yandex.Metrica Logs API
    • Publishing a chart with a map from a CSV file to DataLens Public
    • Visualizing data from AppMetrica
    • Visualizing geodata from a CSV file
  • Step-by-step instructions
    • All instructions
    • Working with connections
      • Creating a ClickHouse connection
      • Creating a connection to a CSV file
      • Creating a MySQL connection
      • Creating a PostgreSQL connection
      • Creating an MS SQL Server connection
      • Creating an Oracle Database connection
      • Creating a Yandex.Metrica API connection
      • Creating a Yandex.Metrica Logs API connection
      • Creating an AppMetrica connection
      • Managing connection access
    • Working with datasets
      • Create dataset
      • Creating a data field
      • Creating a calculated data field
      • Updating fields in datasets
      • Dataset materialization
      • Managing dataset access
      • Managing access to data rows
    • Working with charts
      • Creating a line chart
      • Creating an area chart
      • Creating a pie chart
      • Creating a column chart
      • Creating a bar chart
      • Creating a map
      • Creating a table
      • Creating a pivot table
      • Publishing a chart
      • Managing chart access
    • Working with dashboards
      • Creating dashboards
      • Adding charts to dashboards
      • Adding selectors to dashboards
      • Publishing dashboards
      • Managing dashboard access
    • Working with permissions
      • Granting permissions
      • Deleting permissions
      • Request permissions
  • Concepts
    • Overview
    • Connections
    • Data types
    • Datasets
      • Overview
      • Data model
      • Dataset settings
    • Charts
    • Dashboards
    • Using Markdown in DataLens
    • DataLens Public
    • Calculated fields
    • Marketplace
    • Backups in DataLens
    • Quotas and limits
  • Access management
    • Managing access to DataLens
    • Managing access at the data row level
  • Pricing policy
  • Function reference
    • All Functions
    • Aggregate functions
      • Overview
      • ALL_CONCAT
      • ANY
      • ARG_MAX
      • ARG_MIN
      • AVG
      • AVG_IF
      • COUNT
      • COUNTD
      • COUNTD_APPROX
      • COUNTD_IF
      • COUNT_IF
      • MAX
      • MEDIAN
      • MIN
      • QUANTILE
      • QUANTILE_APPROX
      • STDEV
      • STDEVP
      • SUM
      • SUM_IF
      • TOP_CONCAT
      • VAR
      • VARP
    • Date/Time functions
      • Overview
      • DATEADD
      • DATEPART
      • DATETRUNC
      • DAY
      • DAYOFWEEK
      • HOUR
      • MINUTE
      • MONTH
      • NOW
      • SECOND
      • TODAY
      • WEEK
      • YEAR
    • Geographical functions
      • Overview
      • GEOCODE
      • GEOINFO
      • TOPONYM_TO_GEOPOINT
      • TOPONYM_TO_GEOPOLYGON
    • Logical functions
      • Overview
      • CASE
      • IF
      • IFNULL
      • ISNULL
      • ZN
    • Text markup functions
      • Overview
      • BOLD
      • ITALIC
      • MARKUP
      • URL
    • Mathematical functions
      • Overview
      • ABS
      • ACOS
      • ASIN
      • ATAN
      • ATAN2
      • CEILING
      • COS
      • COT
      • DEGREES
      • DIV
      • EXP
      • FLOOR
      • GREATEST
      • LEAST
      • LN
      • LOG
      • LOG10
      • PI
      • POWER
      • RADIANS
      • ROUND
      • SIGN
      • SIN
      • SQRT
      • SQUARE
      • TAN
    • Operators
      • Overview
      • AND
      • Addition and concatenation (+)
      • BETWEEN
      • Comparison
      • Division (/)
      • IN
      • IS FALSE
      • IS TRUE
      • LIKE
      • Modulo (%)
      • Multiplication (*)
      • NOT
      • Negation (-)
      • OR
      • Power (^)
      • Subtraction (-)
    • String functions
      • Overview
      • ASCII
      • CHAR
      • CONCAT
      • CONTAINS
      • ENDSWITH
      • FIND
      • ICONTAINS
      • IENDSWITH
      • ISTARTSWITH
      • LEFT
      • LEN
      • LOWER
      • LTRIM
      • REGEXP_EXTRACT
      • REGEXP_EXTRACT_NTH
      • REGEXP_MATCH
      • REGEXP_REPLACE
      • REPLACE
      • RIGHT
      • RTRIM
      • SPACE
      • SPLIT
      • STARTSWITH
      • SUBSTR
      • TRIM
      • UPPER
      • UTF8
    • Time series functions
      • Overview
      • AGO
      • AT_DATE
    • Type conversion functions
      • Overview
      • BOOL
      • DATE
      • DATETIME
      • DATETIME_PARSE
      • DATE_PARSE
      • DB_CAST
      • FLOAT
      • GEOPOINT
      • GEOPOLYGON
      • INT
      • STR
    • Window functions
      • Overview
      • AVG
      • AVG_IF
      • COUNT
      • COUNT_IF
      • LAG
      • MAVG
      • MAX
      • MCOUNT
      • MIN
      • MMAX
      • MMIN
      • MSUM
      • RANK
      • RANK_DENSE
      • RANK_PERCENTILE
      • RANK_UNIQUE
      • RAVG
      • RCOUNT
      • RMAX
      • RMIN
      • RSUM
      • SUM
      • SUM_IF
    • Function Availability
  • Questions and answers
  1. Concepts
  2. Charts

Charts

  • Chart type
    • Line chart
    • Area chart
    • Stacked area chart
    • Column chart
    • Normalized column chart
    • Bar chart
    • Normalized bar chart
    • Scatter chart
    • Pie chart
    • Tree chart
    • Flat table
    • Pivot table
    • Map
    • Indicator
  • Multi-dataset charts
  • Publishing a chart
  • Access management

Charts are the visualization of data from a dataset in the form of a table, diagram, or map.

Charts are created in a wizard based on data from one or multiple datasets (see multi-dataset charts).
You can create an unlimited number of charts based on a single dataset.

The workspace in the wizard interface is divided into three main panels:

  1. A dataset panel where available fields are displayed: Dimensions and Measures. You can add a calculated field to the list.
  2. A visualization setup panel where you can select the chart type. Each type has its own set of sections (such as X-axis, Y-axis, and filters) where you can drag and drop fields.
  3. A preview panel where the visualization is displayed.

Charts let you quickly analyze and test hypotheses. You can also save charts and add them to dashboards as widgets.

Warning

DataLens limits the number of data rows displayed in charts. Read about them in the section Quotas and limits.

Chart type

The following types of charts are available in Yandex DataLens:

  • Diagrams:
    • Line chart
    • Area chart
    • Stacked area chart
    • Column chart
    • Normalized column chart
    • Bar chart
    • Normalized bar chart
    • Scatter chart
    • Pie chart
    • Tree chart
  • Tables:
    • Flat table
    • Pivot table
  • Geographical map:
    • Map
      • Point map
      • Choropleth map
      • Heat map
  • Other:
    • Indicator

Line chart

Displays changes to measures by dimension as a single or multiple horizontal lines.

Section
in the wizard
Description
X Dimension. Only one field can be specified
Y Measure. You can specify multiple measures.
If you add more than one measure to a section, the Colors section contains a dimension namedMeasure Names
Y2 Measure. Use it to add a second Y-axis to a chart. You can specify multiple measures.
If you add more than one measure to a section, the Colors section contains a dimension namedMeasure Names
Filters Dimension or measure. Used as a filter
Colors Dimension or the Measure Names field. Affects the color of lines. Measure Names is removed by deleting measures from the Y-axis
Sorting Dimension. Can only use one dimension from the X-axis. Affects the sorting of the X-axis
Signatures Measure. Displays measure values on the chart

Area chart

Displays changes to measures by dimensions as areas, showing the contribution of each line to the total amount.

Section
in the wizard
Description
X Dimension. Only one field can be specified
Y Measure. You can specify multiple measures. If you add more than one measure to a section, the Colors section contains a dimension named Measure Names
Filters Dimension or measure. Used as a filter
Colors Dimension or the Measure Names field. Affects the color of lines. Measure Names is removed by deleting measures from the Y-axis
Sorting Dimension. Can only use one dimension from the X-axis. Affects the sorting of the X-axis
Signatures Measure. Displays measure values on the chart

Stacked area chart

Stacked area chart that shows the ratio of measures as a percentage.

Section
in the wizard
Description
X Dimension. Only one field can be specified
Y Measure. You can specify multiple measures. If you add more than one measure to a section, the Colors section contains a dimension named Measure Names
Filters Dimension or measure. Used as a filter
Colors Dimension or the Measure Names field. Affects the color of lines. Measure Names is removed by deleting measures from the Y-axis
Sorting Dimension. Can only use one dimension from the X-axis. Affects the sorting of the X-axis
Signatures Measure. Displays measure values on the chart

Column chart

Displays data as flat vertical bars.

Section
in the wizard
Description
X Dimensions. One or two dimensions can be specified
Y Measure. You can specify multiple measures. If you add more than one measure to a section, the Colors section contains a dimension named Measure Names. Measure Names can be moved to the X-axis
Filters Dimension or measure. Used as a filter
Colors Dimension or the Measure Names field. Affects the color of lines. Measure Names is removed by deleting measures from the Y-axis
Sorting Dimension or measure. Affects the sorting of columns
Signatures Measure. Displays measure values on the chart

Normalized column chart

Normalized column chart that shows the ratio of measures as a percentage.

Section
in the wizard
Description
X Dimensions. One or two dimensions can be specified
Y Measure. You can specify multiple measures. If you add more than one measure to a section, the Colors section contains a dimension named Measure Names. Measure Names can be moved to the X-axis
Filters Dimension or measure. Used as a filter
Colors Dimension or the Measure Names field. Affects the color of lines. Measure Names is removed by deleting measures from the Y-axis
Sorting Dimension or measure. Affects the sorting of columns
Signatures Measure. Displays measure values on the chart

Bar chart

Displays data as flat horizontal bars.

Section
in the wizard
Description
Y Dimensions. One or two dimensions can be specified
X Measure. You can specify multiple measures. If you add more than one measure to a section, the Colors section contains a dimension named Measure Names. Measure Names can be moved to the Y-axis
Filters Dimension or measure. Used as a filter
Colors Dimension or the Measure Names field. Affects the color of lines. Measure Names can be removed by deleting measures from the X-axis
Sorting Dimension or measure. Affects the sorting of columns
Signatures Measure. Displays measure values on the chart

Normalized bar chart

Normalized bar chart that shows the ratio of measures.

Section
in the wizard
Description
Y Dimensions. One or two dimensions can be specified
X Measure. You can specify multiple measures. If you add more than one measure to a section, the Colors section contains a dimension named Measure Names. Measure Names can be moved to the Y-axis
Filters Dimension or measure. Used as a filter
Colors Dimension or the Measure Names field. Affects the color of lines. Measure Names can be removed by deleting measures from the X-axis
Sorting Dimension or measure. Affects the sorting of columns
Signatures Measure. Displays measure values on the chart

Scatter chart

Displays data points for comparing pairs of values.

Section
in the wizard
Description
X Dimension or measure. Sets the X-axis value
Y Dimension or measure. Sets the Y-axis value
Points Dimension. Specifies the number of points on the chart
Filters Dimension or measure. Used as a filter
Colors Dimension or measure. Affects the color of points
Sorting Measure. Affects the sorting of columns

Pie chart

Displays the size of elements in a single data series relative to the sum of elements as a circle.

Section
in the wizard
Description
Colors Dimension. Only one field can be specified
Measures Measure. Only one field can be specified
Filters Dimension or measure. Used as a filter
Sorting Dimension or measure from the Colors section. Affects the sorting
Signatures Measure. Displays measure values on the chart

Tree chart

Displayed as a set of rectangles. Use this chart to compare proportions in a hierarchy.

Use this chart to compare proportions in a hierarchy.

Section
in the wizard
Description
Dimensions Dimensions. Determines the hierarchy tree of nested rectangles
Size Measure. One measure that determines the area of a rectangle
Filters Dimension or measure. Used as a filter
Colors Dimension or measure. Affects the shading of rectangles in a chart

Flat table

Displays data in table format, where the first row defines the names of fields and the remaining rows define their values.

Section
in the wizard
Description
Columns Dimensions and measures to be used as columns. Field names are used as column headers
Filters Dimension or measure. Used as a filter
Colors Measure. Affects shading of all cells within a row. It may contain only one indicator
Sorting Dimensions and measures specified in the Columns section.
You can use multiple dimensions and measures.
The order of fields in a section affects the sorting order of table fields

Pivot table

Displays data in table format, where rows and columns may contain dimension values and cells at their intersection may contain measures.

Section
in the wizard
Description
Columns Dimensions
Rows Dimensions
Measures Measures. If you add more than one measure to a section, the Columns section contains the Measure Names dimension that defines the location of the measure headers. Measure Names can be moved to Rows
Filters Dimension or measure. Used as a filter
Colors Measure. Affects shading of all cells containing indicators. It may contain only one indicator
Sorting Dimensions and measures specified in the Columns and Rows sections.
You can use multiple dimensions and measures.
The order of fields in a section affects the sorting order of table fields

Map

Map supports three types of visualization:

  • Point map
  • Choropleth map
  • Heat map

You can place no more than 5 layers with any visualization type on a map. Layers in the Map chart are called geolayers.

Geolayers visualize indicators using points or polygons on the map.

You can do the following operations with geolayers:

  • Change name.
  • Set transparency level.
  • Reorder the layers inside a same visualization type. However, you can't change the order of visualization types (top-to-bottom: point map, chloropleth map, heat map).

You can purchase pre-calculated geolayers from partners in Cloud Marketplace.

Point map

Displays geographical points on the map.

Section
in the wizard
Description
Geopoints Measure with the type Geopoint
Size Measure. Affects the size of the point
Layer filters Dimension or measure. Used as a filter for the current layer
General filters Dimension or measure. Used as a filter for the whole chart
Colors Dimension or measure. Affects the intensity of point fill
Tooltips Dimension or measure. A tooltip that appears when you hover over a point
Signatures Measure. Displayed as text on a point. When used, point size control is blocked

Choropleth map

Displays shaded areas on the map.

Section
in the wizard
Description
Geopolygons Measure with the type Geopolygon
Layer filters Dimension or measure. Used as a filter for the current layer
General filters Dimension or measure. Used as a filter for the whole chart
Colors Dimension or measure. Affects the color of points

Heat map

Displays geographical points on the map with different shading intensity.

Section
in the wizard
Description
Geopoints Measure with the type Geopoint
Filters Dimension or measure. Used as a filter for the current layer
General filters Dimension or measure. Used as a filter for the whole chart
Colors Dimension or measure. Affects the intensity of point fill

Indicator

Displays the data as one number.

Section
in the wizard
Description
Measure Measure. One measure that determines the indicator value
Filters Dimension or measure. Used as a filter

Multi-dataset charts

Multi-dataset charts display data from multiple datasets.

Queries for each dataset are processed independently of each other. Calculated fields can't be applied to fields from multiple datasets.
When you add a second dataset, the link is automatically created based on the first match for the field name and field data type.

In this case, you can:

  • Change links.
  • Add new links.
  • Delete links.

Note

Datasets used in the chart may be non-linked.

Specifics of working with linked datasets in the chart, except for geochart layers:

  • One chart can use any measures from datasets, regardless of their links.
  • One chart can only use linked dimensions.
  • Filters by linked dimensions are applied to all datasets.
  • Filters by non-linked dimensions are applied only to their own dataset.

Working with linked datasets in geovisualizations on different layers:

  • A geolayer can use any measures from datasets regardless of their links
  • A geolayer can only use its linked dimensions.
  • Filters by linked dimensions from the General filters section are applied to all datasets in all layers.
  • Filters from the General filters section that use non-linked dimensions only apply to their own dataset in all layers.
  • Filters in the Layer filters section that use linked dimensions apply to all datasets within the current layer.
  • Filters in the Layer filters section that use non-linked dimensions only apply to their own dataset within the current layer.
  • There are no restrictions on using non-linked dimensions in different layers.

Publishing a chart

You can grant any internet user access to a chart using DataLens Public. This chart becomes public and any user can view it without authorization.

Warning

Before publishing any data, make sure that your charts and dashboards don't contain any personal data or trade secrets. Access to published data is not restricted.

Access management

You can configure chart permissions. For more information, see Managing access to DataLens.

See also

  • Creating a line chart
  • Creating a pivot table
  • Creating a table
  • Creating an area chart
  • Creating a column chart
  • Creating a bar chart
  • Creating a pie chart
  • Creating a map
  • Publishing a chart
In this article:
  • Chart type
  • Line chart
  • Area chart
  • Stacked area chart
  • Column chart
  • Normalized column chart
  • Bar chart
  • Normalized bar chart
  • Scatter chart
  • Pie chart
  • Tree chart
  • Flat table
  • Pivot table
  • Map
  • Indicator
  • Multi-dataset charts
  • Publishing a chart
  • Access management
Language
Careers
Privacy policy
Terms of use
© 2021 Yandex.Cloud LLC