Exercise

Calculating aggregated variables

In the previous exercise you constructed two basetables corresponding with two snapshots, and added the target values to these basetables. In this exercise, you will learn how to add aggregated variables. You will add the sum of donations last month (December 2016 and December 2017 for the respective snapshots) to both basetables.

Instructions 1/2

XP

1
2

gifts_december_2016 contains all donations made in December 2016. For each donor, calculate the maximum donation made.
gifts_december_2017 contains all donations made in December 2017. For each donor, calculate the maximum donation made.

Take Hint (-15 XP)