On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
1. Introduction
Basic multi-level aggregation
Multi-level aggregation in groups
Multi-level aggregation with custom classification
Three or more aggregation levels


Hello! Welcome to the next part of our course. This time, we'll be talking about multi-level aggregation – i.e., reports in which we first calculate a metric and then find the average value of that metric.

Our reports will answer questions like:

  • What is the average order value?
  • What is the average number of items in a single order for various shipping countries?

All such questions require us to perform multi-level aggregation. Sound complicated? Don't worry, we'll go through everything step by step!


Click Next exercise to continue.