Hi there,
I'm aware that you cannot filter by an aggregate (even if created in breast mode). I'm wondering how I could create the aggregate in magic ETL or SQL. My knowledge on both is quite limited.
My raw data looks something like this:
Staff Course
Jon course 1
Jon course 2
Suzie course 1
Jon course 3
I would like it to look like this from the ETL/SQL so I can then filter by who has completed 2+ courses.
Staff Count of distinct course
Jon 3
Suzie 1
Thank you in advance