Combo
A combo chart lets you display multiple data insights on the same chart.
A Combo chart lets you display multiple data insights on the same chart and visually highlight the differences between data sets. You can also customize each selected graph as you need.
You can combine these graph types:
Input
The Combo chart requires numeric columns.
Configuration
Use the following configuration options to configure the Combo chart.
Note
The Configuring the Combo chart gives configuration options through the Pipes module. If you have charts already created, you can access them through your Dashboards.
Go to the Pipes module from the side navigation bar.
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.
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.
Add tools to build out your pipe. For more information about adding tools to your pipe, see the Using the Pipe builder canvas documentation.
Create a chart from your pipe by clicking Charts on the canvas toolbar.
Click Create Chart.
The chart page opens.
In the configuration pane, enter the following information:
Table 121. Combo chart configurationField
Description
Setup tab
The Setup tab allows you to define the tool, chart type and other settings.
Tool
Select the tool in your pipe that you want to create a chart for.
Chart type
Type Combo and click on the Combo graphic to select it.
X axis
Select the column to use as the X axis.
Series
Select one or more columns to use as the data you want to analyze.
Advanced section
The Advanced section allows you to configure output settings to ensure accurate and efficient data processing and visualization.
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.
Series type
Choose between Column or Line for each column.
Sort
Select to sort your chart data by Descending or Ascending, None.
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
Selected columns
Calculate the series column with one of the following operations:
Sum
Count
Average
Max
Min
Median
OR
AND
STDEV
Customize section
The Customize tab allows you to configure the output settings to ensure compelling visualizations.
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 arrows to increase or decrease the number.
Axis
Select the left or right access to plot on the chart for each column.
Colour
Click on the column colour to change it.
Legend
Select the Include legend checkbox to add a legend to your chart.