Aggregation

Automatic aggregation is applied to most charts in InstaCharts.

You can change the aggregation function applied through the Math dropdown, located within the Y-Axis dropdown on the chart toolbar.

Aggregating Impressions by Date with sum, count, average and median

Aggregation performs calculations on a set of values and returns a single value. In the video above, the values on the y-axis are changing as the aggregation is changed.

Aggregation Functions

Below is a list of the aggregation functions you can apply to the Y Axis. In the UI, they appear next to the Y Axis under the Math dropdown.

Numerical Y Axis

These are mathematical functions applied to the numerical values within a column:

• Sum Add all values together
• Count Counts number of rows
• Average Average of all values
• Median Middle value
• Min Smallest value
• Max Largest value

Note

Numerical columns are heavily pushed by the app to be displayed in the Y Axis, so that one of these numerical aggregation functions can be applied

All Y Axis Types

These are the functions that can be applied to non numerical values:

• Distinct Count of different values
• Valid Counts rows with a value
• Missing Count of rows missing a value

Note

Distinct is useful to count the number of different values in a column, while Valid and Missing are useful for error checking your data.