custom filters for Scorecard view
Is there a way to pre-filter the data before the Scorecard aggregations in Data Studio?
For example, i have a sheet with three columns: student, class and score. I want to show a simple scorecard of # of students with at least one passing class (where score > 50).
Query would be something like this:
select count(distinct student) from tableName where score > 50
In Data Studio, when i use the scorecard to show count_distinct(student) with a custom filter on score > 50, it'll just return count of all students regardless of score.
Any ideas on how to accomplish the above?