Multi-level aggregations
The regional marketing team wants to gain a deeper understanding of customer demographics. They now need a new report.
It must show the total number of customers in each region and the median customer age. The median is better than the mean. It's less affected by outliers. So, it represents the typical customer with greater accuracy. Use KNIME's GroupBy node. It will automate the process and generate the report. This will ensure accurate demographic insights for each region.
This exercise is part of the course
Data Manipulation in KNIME
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
