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

aggregate-number-of

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

aggregate

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

3

aggregate

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

4

aggregation example

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

Image