Combo

The Combo chart combines the functionality of a number of existing chart types and can display multiple data series in a variety of configurations. This flexibility makes it easier to create, change, and manipulate charts in a variety of formats without having to create a number of different chart types on your dashboard.

The Combo chart is highly customizable; you can change type and orientation on the fly, switching between a number of different types and views to get the most effective chart for your data. New Combo chart configuration drop downs allow you to sort and filter by data type, making data discover easier and faster. For numerical base dimensions, you can configure measures to display as cumulative and percentage distributions. You can select dimension values dynamically or manually, and configure sorting logic you want to use.

You can pin chart legends to the right, or you can superimpose them on the chart. You can also use the chart legend to toggle on or off the visibility of an individual group-by series.

Chart orientation can be toggled between vertical and horizontal. If you have bar and Combo charts that you have created previously, you can duplicate them as New Combo charts at the Dashboard level.

Example 1

This example shows some of the flexibility of the Combo chart. You want to create a chart that shows the number of flight arrivals for each selected carrier. Create a Combo chart based on the flights data source, configure the chart type and granularity, and customize how the Group by dimension displays. Start by opening a new Dashboard, and then click the New Combo chart type.

Select the flights data source, and set the following dimensions**:**

• Base dimension: arr_timestamp

• Group by dimension: carrier_name

• Base measure: # Records

This results in the following chart.

In Legends and Settings, you can configure the existing chart in a variety of ways:

• Change the type/orientation of the chart to Vertical, Horizontal, Group (Lines for Line/Area charts), Stack, and Percentage.

• Toggle Range charts on and off.

• Adjust data and formatting settings.

• Customize the Group by dimension.

Let's change the chart to a Line/Area chart, and adjust the granularity:

• In Graphical settings, select Line/Area and change the line thickness to 3.

• In the Bin: dropdown, select Quarter.

Say you want to customize the number of carriers displayed. In addition to the dynamic values that already appear, you can manually select other airlines to appear in the chart.

• Open the carrier_name Group by dimension by clicking the settings icon to the right.

• Click + Manual Selection, and then select additional airlines. When you have finished, click Done.

Now, 10 airlines are defined, and those selected manually appear with a lock icon to the right.

If you click the color next to the carrier name, you can change it. You can also hide a carrier from view by clicking the eye icon that appears when you hover over the carrier name.

Example 2

Let's create a chart that shows the number of flights based on origin city, and then see how many flights orginated from each city based on airline.

Create a chart using the flights data source, with the following:

• Base dimension: origin_city

• Base measure: # Records

The chart created looks like this. You can scroll horizontally to see values that are not displayed because of space constraints.

Let's add the carrier_name dimension, change the orientation to Horizontal, and select Stack to create a stacked bar chart.

You apply filters in the same way as you would with other chart types. Here, you decide you want to see only those flights for month December. Click + Add filter, and select flight_month Equals 12. You can toggle this filter on and off.

Duplicating and Upgrading Other Chart Types to New Combo Charts

You can copy or upgrade compatible chart types (Combo, Bar, Histogram, and Stacked Bar) as New Combo charts at the Dashboard level. Copying a chart preserves the original chart and makes a duplicate New Combo chart; upgrading converts that chart to a New Combo chart.

To duplicate an individual chart or convert it as a New Combo chart, click the More Options icon at the far right, and then click Duplicate as New Combo or Upgrade to New Combo.

If you select Duplicate as New Combo, an identical chart of New Combo type is created and added to the dashboard.

If you select Upgrade to New Combo, that chart is converted to a New Combo chart and the original chart is no longer available.

You can also convert all upgradable charts on a dashboard at once by clicking the More option menu on the dashboard and then clicking Upgrade charts.

In the Upgrade Charts on Page dialog box, you can select the charts you want to upgrade or cancel the upgrade.

If you do not save the dashboard after the conversion, the charts revert back to their original format and the conversion is lost.