Contact UsGet started

Chart settings

Written by
Updated at October 23, 2024

Charts are configurable. For example, you can choose to display a legend, customize a color scheme, or set your own title.

Available settings depend on the type of chart being configured.

General settings

General settings affect the overall display of charts.
To open general settings, click on the left side of the screen above the chart.

Warning

The settings specified below may not be available for some chart types.

Name

Description

Header

Sets the header for the chart.

Possible values:

  • Hide: Hide header.
  • Show: Show header. You can enter the header text in the text field on the right.

Legend

Displays the legend below the chart. The legend contains chart colors with text descriptions referring to the field values in the ** section.

Possible values:

  • Hide: Hides the legend.
  • Auto: Displays the legend if the field is specified in the Colors section.

Sum in tooltips

Displays a sum in a tooltip when you hover over the chart display.

Possible values:

  • On: Displays a sum in a tooltip.
  • Off: Hides a sum in a tooltip.

Navigator

Displays an additional element below the chart, the navigator. Allows reducing a data selection displayed in the chart.

Possible values:

  • On: Shows the navigator.
  • Off: Hides the navigator.

For more information, see this guide.

Pagination

Breaks a table into pages.

Possible values:

  • On: Displays the table part by part across a number of pages.
  • Off: Displays the whole table.

Limit

Sets the number of rows to export. This is also the number of rows displayed per page. Available if Pagination is enabled.

Grouping

Displays unique field values.

Possible values:

  • On: Displays unique values.
  • Off: Displays all values.

Totals

Displays a row with total values for table columns. Values in the row are calculated using the same formulas as aggregation in the relevant measure.

Possible values:

  • On: Shows the Total row.
  • Off: Hides the Total row.

Field settings

You can configure:

To open settings of a dimension or a measure, click the icon to the left of its name.

Note

If you apply an aggregation to the dimension, it will become a measure and the relevant settings will become available for it.

Dimensions

Name

Description

Parameter

Sets dimension name.

Type

Sets dimension data type.

Grouping

Sets grouping or rounding type. The setting is only available for dimensions of the Date and Date and time type.

Format

Sets value display format.

Date mode

Sets date display mode. This setting is only available for dimensions of the Date and Date and time type.>
Possible values:

  • Continuous: Displays all dates continuously.
  • Discrete: Displays dates that contain values.

Aggregation

Sets aggregation type. Aggregation functions are available according to the Aggregating data table.

Markdown

The field value will be formatted according to Markdown. Only available for String type fields.

Sub-totals

Shows columns and/or rows with subtotals. This setting is only available for Pivot table charts.

Measures

Name

Description

Parameter

Sets measure name.

Type

Sets measure data type. Not available for QL charts.

Aggregation

Sets aggregation type. Aggregation functions are available according to the Aggregating data table. Not available for QL charts.

Markdown

The field value will be formatted according to Markdown. Only available for String type fields.

Format

Sets value display format.

Decimal places

Sets the number of characters displayed after the decimal point. Not available for QL charts.

Display groups of thousands

Enables displaying groups of thousands for numeric values.

Possible values:

  • With separator: Displays spaces between groups of thousands.
  • Merged: Hide spaces between groups of thousands.

Prefix

Sets the text displayed before a value.

Postfix

Sets the text displayed after a value.

Dimension

Sets the rounding scale for values.

Section settings

To open section settings, click in the row with the section name.

Axes

Axis settings are only available for charts that have at least one X or Y axis:

  • Line chart.
  • Area chart (stacked and normalized).
  • Column chart (including a normalized column chart).
  • Bar chart (including a normalized bar chart).
  • Scatter chart.

You can configure settings for both the X and Y axes.

Warning

Some of these settings may not be available for some axes.

Name

Description

Axis name

Sets axis label.

Possible values:

  • On: Use the field name. If the section contains multiple fields, DataLens uses the name of the field listed first.
  • Off: No axis label displayed.
  • Manually: Allows setting an axis name manually in a text field.

Axis type

Defines axis type. This setting is available if fields in the axis section are of the Fractional number type.

Possible values:

  • Linear: Use linear axis.
  • Logarithmic: Use logarithmic axis. Suitable for charts with a large spread of values. The logarithmic axis allows you to display a fast-growing graph in a convenient form for analysis, reducing values by an order of magnitude.

Display mode

Enables configuring continuous chart display.

Possible values:

  • Discrete: Plots the chart only for non-null values.
  • Continuous: Plots the chart for all values continuously. You can only use continuous mode for the Integer, Decimal, Date, or Date and time data types.

Axis formatting

Sets the formatting of numerical axis labels.

Possible values:

  • Auto: Default formatting.
  • By first field on the X axis: Displays the X axis labels with the formatting specified in the Format setting for the first field in the X section. Available in the X axis settings.
  • By first field on the Y axis: Displays the Y axis labels with the formatting specified in the Format setting for the first field in the Y section. Available in the Y axis settings.

Grid

Enables/disables grid display in a chart.

Possible values:

  • On: Shows the grid.
  • Off: Hides the grid.

Grid increments, px

Sets grid increment in pixels. Available if Grid is enabled.

Possible values:

  • Auto: Calculates grid size automatically.
  • Manually: Requires manual input of grid size in pixels.

Labels

Shows or hides axis labels based on field values.

Possible values:

  • On: Shows axis labels.
  • Off: Hides axis labels.

Label appearance

Sets the way the labels are displayed. Available if the Labels setting is enabled.

Possible values:

  • Auto: Displays axis labels.
  • Horizontal: Displays axis labels horizontally.
  • Vertical: Displays axis labels vertically.
  • Angled: Displays axis labels at a 45-degree angle.

Null values

Allows selecting a null value handling method.

Possible values:

  • Hide: Hides null values in charts.
  • Connect: Connects field values where there are null values in between.
  • Display as 0: Displays null values in charts as zero (0) field values.

Scaling

Sets the chart axis scale.

Possible values:

  • Auto: Enables autoscaling. You can specify how DataLens sets the scale: from 0 to the maximum field value (Autoscale from 0 to max) or from the minimum to the maximum field values (Autoscale from min to max).
  • Manually: Requires manual input of the axis scale. You can set the maximum and minimum values along the axis. DataLens will trim the chart lines by this value.

Colors

Generally, you can set a specific color for any graph value.

The following settings are available for a tree diagram, a table (including a pivot table), and a map:

Name

Description

Gradient type

Sets the number of colors in the gradient.

Possible values:

  • Two-color: Sets two colors for the gradient.
  • Tree-color: Sets three colors for the gradient.

Color

Sets a color for a value. Available colors depend on the gradient type.

Set threshold values

Allows setting threshold values for each color.

Borders

Sets borders for geopolygons.

Possible values:

  • Show: Displays geopolygon borders.
  • Hide: Hides geopolygon borders.

You can create color palettes and use them in your charts.

Labels

Labels display measure values on the chart. Markup functions are supported. For String type fields, you can configure using basic Markdown syntax: click the icon before the field name and enable Markdown.

Labels are available for the following charts types:

  • Line chart.
  • Area chart (stacked and normalized).
  • Column chart (including a normalized column chart).
  • Bar chart (including a normalized bar chart).
  • Pie chart.
  • Map.

Sorting

Allows you to sort chart values by measure or dimension.

Sorting is available for the following chart types:

  • Line chart.
  • Area chart (stacked and normalized).
  • Column chart (including a normalized column chart).
  • Bar chart (including a normalized bar chart).
  • Pie chart.
  • Table (including a Pivot table).

Filters

Filters allow you to make a selection of values by dimension or measure.
Filters are available for all chart types.

Map section settings

You can configure layers, point size and color, tooltips, and filters.
To open section settings, click in the row with the section name.

Warning

Depending on the visualization type, different settings are available.

Name

Description

Disk

Sets point size depending on the measure value.

Colors

These set a color for geopoints and geopolygons depending on the measure value.

Tooltips

These create a tooltip displayed when you hover over a point. The tooltip contains dimension and measure values. For String type fields, you can configure using basic Markdown syntax: click the icon before the field name and enable Markdown.

Layer filters

Create a selection by dimension or measure for the current layer.

General filters

Create a selection by dimension or measure for the whole chart.

Layers

You can add up to five layers with any visualization types to a single map:

  • Scatter chart: Geopoints dimension type.
  • Choropleth map: Geopolygons dimension type.
  • Heat map: Geopoints (heat map) dimension type.

You can delete and rename layers.

You can change the transparency of the current layer using the slider. You can also set transparency of a text field above the slider.

slider

Transparency can have a value from 0 to 100.

Colors

You can set a color for geopoints and geopolygons, which will depend on the measure value.

Name

Description

Gradient type

Sets the number of colors in the gradient.

Possible values:

  • Two-color: Sets two colors for the gradient.
  • Tree-color: Sets three colors for the gradient.

Borders

Sets borders for geopolygons.

Possible values:

  • Show: Displays geopolygon borders.
  • Hide: Hides geopolygon borders.

Color

Sets a color for geopoints and geopolygons. Available colors depend on the gradient type.

Set threshold values

It allows you to set threshold values that will refer to each color.

You can create color palettes and use them in your charts.

Previous
Overview
Next
Measure Values and Measure Names