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

custom filters for Scorecard view

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

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: https://docs.google.com/spreadsheets/d/1iBi3mW_qD7GX_uGYdJDuULOJc16hsyAKJFHR57nifYA/edit?usp=sharing

 

Any ideas on how to accomplish the above?

 

thanks