Data Studio
2.4K members online now
2.4K members online now
Ask questions about Data Studio
Guide Me

custom filters for Scorecard view

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭



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.


Sample google sheet:


Any ideas on how to accomplish the above?