Filter by aggregate work around?
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…