Skip to main content

Varicent ELT Help Center

Area smooth line

Abstract

Use the Area smooth line chart to show magnitude or change over time.

Use the Area smooth line chart to show magnitude or change over time. The Area smooth line chart can help visualize trends by highlighting how values can change over time and show cumulative totals.

An area smooth line is similar to an area line, but with the lines between data points smoothed out.

Area_smooth_line.svg

Input

The Area smooth line chart requires both text and numeric columns to use in the chart.

Configuration

Use the following configuration options to configure the Area smooth line chart.

Note

The Configuring the Area smooth line chart gives configuration options through the Pipe module. If you have charts already created, you can access your charts through your Dashboards.

Configuring the Area smooth line chart
  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In the Pipe builder, add at least one data source to your pipe. For more information on adding a data source, see the Data tool.

  4. Add tools to build out your pipe. For more information about adding tools to your pipe, see the Using the Pipe builder canvas documentation.

  5. Create a chart from your pipe by clicking Charts on the canvas toolbar.

  6. Click Create Chart.

    The chart page opens.

  7. In the configuration pane, enter the following information:

    Table 100. Area smooth line chart configuration

    Field

    Description

    Setup tab

    Tool

    Select the tool in your pipe that you want to create a chart for.

    Chart type

    Type Area smooth line and click on the Area smooth line graphic to select it, or press enter.

    X axis

    Select the numeric column to use as the X axis.

    Y axis

    Select the numeric column to use as the Y axis.

    Series

    Select the text or numeric column to use for the chart.

    Advanced section

    Show

    Select either Preview or Last built

    • Preview displays the first 100 rows of your data from your last build.

    • Last build displays the first 1000 rows of your entire dataset from your last build.

    Size

    Select the numeric column to use for the size.

    Sort

    Select to sort your chart data by None, Ascending or Descending.

    Aggregate?

    Click the Aggregate? checkbox to aggregate your chart data.

    All

    Calculate all columns that you select with one of the following operations:

    • Sum

    • Count

    • Average

    • Max

    • Min

    • Median

    • OR

    • AND

    • STDEV

    Customize tab

    Chart and axis titles

    Select the following to add titles to your charts:

    • Include chart title

    • Include chart subtitle

    • Include horizontal axis title

    Horizontal axis label angle

    Select the degree from the drop-down list of the angle for the horizontal axis label.

    Include vertical axis title checkbox

    Select to add the vertical axis title.

    Vertical axis label angle

    Select the degree from the drop-down list of the angle for the vertical axis label.

    Left margin

    Enter the padding for the left margin or click the arrows to increase or decrease the number.

    Right margin

    Enter the padding for the right margin or click the arrows to increase or decrease the number.

    Top margin

    Enter the padding for the top margin or click the arrows to increase or decrease the number.

    Bottom margin

    Enter the padding for the bottom margin or click the arrow to increase or decrease the number.

    Colour

    Click on the column colour to change it.

    Legend

    Select the Include legend checkbox to add a legend to your chart.



Usage example

For example, you want to see the difference between each of your sellers sales amounts for every quarter in 2024. Using the Area smooth line chart, the data displays the amounts for each seller.

Figure 12. Area smooth line chart
Area smooth line chart

The Area smooth line chart displays the sellers sale amounts for each quarter.



When you hover over each point in the chart, you can see the data for an individual seller:

AreaSmoothLineChart2.png