Charts
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:
- A dataset panel where available fields are displayed: Dimensions and Measures. You can add a calculated field to the list.
- 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.
- 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:
- Tables:
- Geographical map:
- Other:
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 named Measure 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 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 |
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:
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.