Sentence Builder

How to aggregate by another column

AddMaple allows you to aggregate one column by another. For example if you have a numeric column - Salary, and a categorical column - Age Range, you can use AddMaple to view median salary by age range.

You can aggregate from any pivot chart by clicking on the "Number of" button in the sentence bar.

1

Open the Number of menu to choose an aggregation type.

This will bring up the aggregation options.

1. Total amount of - this is like SUM on a spreadsheet, when you select this you will be given a list of numeric columns to choose from

2. Average - this is like AVERAGE on a spreadsheet and calculates the mean. After selecting you will give given a list of numeric columns to choose from

3. Median - this calculates the median and also requires you to select a numeric column

4. Count of unique - this allows you to aggregate by a categorical column. There is an example further down in this guide.

2

Aggregation options include Total, Average, Median, and Count Unique.

Once you select an aggregation type, AddMaple will add another dropdown allowing you to select your aggregation column.

3

After choosing a type, select the column to aggregate by.

In this example we can see the median annual compensation per age range.

4

Example: median annual compensation per age range.

This is another example showing the "Count Unique" aggregation option. Here we can see the unique industries represented per database environment (this is from a developer survey).

5

Example: unique industries per database environment using Count Unique.