AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
5.2K members online now
5.2K 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