Area chart in DataLens On-premises

This chart shows how a measure changed over time. The area between the axis and the plotted line is filled with color to indicate volume.

If you have multiple data categories, the areas will be stacked one on top of the other or overlap, depending on the setup.

Example

Be careful selecting the measures when building your chart. For example, do not add the number of customers to the sales amount, or the purchase amount to the sales amount.

Wizard sectionsWizard sections

Creating an area chartCreating an area chart

To create an area chart:

1. Go to the DataLens home page.

2. In the left-hand panel, select Charts.

3. Click Create chart → Chart.

4. At the top left, click Select dataset and specify the dataset to visualize. If you do not have a dataset, create one.

5. Select Area chart as the chart type.
6. Drag a dimension from the dataset to the X section. The values will be displayed in the lower part of the chart on the X axis.
7. Drag one or more measures from the dataset to the Y section. The values will be displayed as areas along the Y axis.

Configuring display of valuesConfiguring display of nullvalues

• If the source data has a row with null for a measure value, this point will not be plotted on a chart with default settings.

  For example, if the source has a row with the date, 20.07.2022, but the sales total for it is not specified.

  To set up null value display on a chart:

  1. Click in the top-right corner of the section with the measure you want to configure (the icon appears when you hover over the section).
  2. In Empty values (null), select Display as 0.
  3. Click Apply. Now the chart will use 0 instead of null.

• If a row is missing from the source data altogether, the chart section settings will not change the chart.

  For example, if the source does not have a row with the particular date, 20.07.2022, nothing will be shown for this date on the chart.

For more information, see Configuring the display of null values in a DataLens On-premises chart.

Configuring a stacked chartConfiguring a stacked chart

Use the Stacking option in the chart settings to toggle between stacked or unstacked chart display.

• A stacked chart shows a ratio of measures by category to the total value. Use this chart type when you need to see how each measure contributes to the total.

  For example, you can get the breakdown of total sales by product category. If you have multiple data categories, the areas are stacked one on top of the other. The top line represents all data.

• An unstacked chart shows the changes in a measure separately for each category. You can use this chart type when you need to compare measures by categories.

  For example, total sales in each product category. If you have multiple data categories, the areas overlap. Each line corresponds to measure values for an individual category.

  Example

  

RecommendationsRecommendations

• Labels. If the category values are too verbose, make them shorter so that the chart labels look neater.

  You can use string functions in calculated fields or the CASE conditional statements.

• Areas. Do not display more than three to five areas on the chart.

• To make it easier to track the dynamics, place the largest or most important categories closer to the chart base. To do this, drag the measure to the Sorting section or set up their order in the Y section.

  For example, you can do so to track sales dynamics in the Household cleaners category.

  Chart example

  

• Splitting. You can split a chart by dimension into several small, easy-to-compare charts. To do this, drag a dimension from the dataset to the Split section.

  Chart example

  

Useful linksUseful links

• Creating a dashboard in DataLens On-premises
• Adding a chart to a dashboard in DataLens On-premises
• Adding a selector to a dashboard in DataLens On-premises