Skip to main content

Varicent ELT Assistant

Stacked column

Use the Stacked column chart to show the relative value of different grouped categories or to show ranked values.

A stacked column chart shows data represented by vertical rectangular bars with comparative values stacked on top of each other.

Each group is represented by two or more vertical bars. The length of the rectangle is proportional to the value it represents.

Stacked_column.svg

For example, you can use the Stacked column chart to show revenue for different products at two different store locations. In the chart, each bar represents the difference in revenue between the locations for each product.

Input

The Stacked column chart requires numeric columns.

If some of your categories contain negative values, use a standard column chart instead.

Configuration

Use the following configuration options to configure the Stacked column chart.

Note

These steps provide configuration options through the Pipe module. If you have already created charts, you can access them through your Dashboards.

  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 a data source to your pipe. For more information on adding a data source, see the Data Input tool.Data Input

  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. From the configuration pane, go to the Setup tab, and select the tool that you want to create a chart for.

    Note

    Whatever tool you select in your pipe when you add the chart is selected by default.

  8. Under Chart type, start typing Stacked column to filter the list, then click the Stacked column graphic to select it.

  9. Under the X axis, select a column. The X axis populates the data along the chart's horizontal axis.

  10. Under Series, select the numeric column to use for the chart.

  11. Expand the Advanced field, click Show to 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.

  12. Under Sort, select to sort your chart data by None, Ascending or Descending.

  13. Click Aggregate? to aggregate your chart data.

  14. Under All, select the operation to calculate your columns with:

    • Sum

    • Count

    • Average

    • Max

    • Min

    • Median

    • OR

    • AND

    • STDEV

  15. Under Series, select the operation to calculate your series columns with:

    • Sum

    • Count

    • Average

    • Max

    • Min

    • Median

    • OR

    • AND

    • STDEV

  16. Click the Customize tab to add custom styling to your chart.

    1. Under Chart and axis titles, select the following to add titles to your charts. To update the title from "Untitled" to something meaningful, click on the title to edit.

      • Include the chart title

      • Include chart subtitle

      • Include the horizontal axis title

    2. Under Horizontal axis label angle, select the degree from the drop-down list of angles for the horizontal axis label. This option is useful if you have longer labels, as angling the text can free up more space in your chart.

    3. Click the Include vertical axis title checkbox to add the vertical axis title.

    4. Under Vertical axis label angle, select the degree from the drop-down list of angles for the vertical axis label.

    5. Under Left margin, enter the padding for the left margin or click the arrows to increase or decrease the number.

    6. Under Right margin, enter the padding for the right margin or click the arrows to increase or decrease the number.

    7. Under Top margin, enter the padding for the left margin or click the arrows to increase or decrease the number.

    8. Under Bottom margin, enter the padding for the left margin or click the arrows to increase or decrease the number.

    9. Under Colour, expand the colour field, click on the column colour, and select a new colour.

    10. Under Legend, select the Include legend checkbox to add a legend to your chart.

  17. Click Return to pipe to go back to your pipe. To view your chart or create a dashboard for your charts, read the Dashboards documentation.