Hi QuickSight Community,
avgOver(avg(Questions), [Course]) →
Is there any way to get the total number of questions in all courses if sum(avgOver(…)) is not allowed?
Having a dataset that doesn’t include participants is not an options because some filters/controls are in place. E.g. filtering by students from EMEA would change the total number of questions from 123+222+999+808 to 123+808 because there are no students from EMEA in course Y and Z.
I hope it makes sense. I’d appreciate any kind of help!