Create a Single-Series Chart with Multiple Aggregations

You can create a single-series chart that contains multiple aggregated values. These aggregated values can be from either the same field or different fields in your data source. Use this functionality to visualize multiple aggregated values without grouping your data into categories.

Supported Chart Types

You can include multiple aggregations in your single-series chart on the following chart types:

Grouped and Stacked Bar Charts
Grouped and Stacked Column Charts
Discrete Line Charts
Discrete Area Charts

Procedure

To create a single-series chart that contains multiple aggregated values:

In the Chart Builder, drag a field to the Aggregation encoding channel.

Select the desired aggregation for your field.

Drag an additional field to the empty Aggregation encoding channel that appears below the first.

Note

You can reuse the same field in multiple Aggregation encoding channels to perform different aggregations on the same field.

Select the desired aggregation for the next field.

Drag any additional fields you want to include in your chart into an empty Aggregation encoding channel and select their aggregation method.

Behavior

When you encode multiple aggregation fields, the Series encoding channel is disabled.
When you create a single-series chart with only aggregated values, each aggregated value is treated as its own category. If you encode a Category field in addition to your aggregation fields, the aggregated values become series (instead of categories). To learn more, see Map Multiple Fields to a Single Axis.

Example

The following chart uses the Sample Data: Movies data source to show the mean IMDB and Rotten Tomatoes ratings across all movies.

click to enlarge

The chart contains two aggregation encoding channels:

Mean imdb.rating
Mean tomatoes.rating

Since no field is applied to the category encoding channel, the chart shows the mean ratings across all movies, irrespective of any categorical grouping.

Back

Apply a Suggested Chart

Create a Multi-Series Chart