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
1.4K members online now
1.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Numeric filters for Scorecards are not working

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

The numeric filters which work for other kinds of charts are not working for scorecards. I tried it with google sheet and mysql data sources

 

Created a test report to demonstrate this - 

 

Report - https://datastudio.google.com/open/0B8tYXdBAKJZwVUdnSmgwZ2poejg (with edit access)

 

Data Source - https://docs.google.com/spreadsheets/d/1BsvwJ6kpX-b6po583Pew7Cau97fMwSmz2207AKjai1o/edit#gid=0 (with edit acess)

 

The Numeric filter filter works for the table chart but not for the scorecard

 

 

Numeric filters for Scorecards are not working

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

it is working as designed, you are filtering count >3, the scorecard show 14 which is the overall total, as it ignore the dimension. 

Numeric filters for Scorecards are not working

[ Edited ]
Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

- Thanks Mimoune for your response. 

 

To illustrate the problem more clearly, I updated the report and the data source. Please check once.

 

I have created two filters with the same condition but of different data types - a string filter and a numeric filter

 

1. String filter on Table - Works as expected

2. String filter on Scorecard - Works as expected

3. Numeric filter on Table - Works as expected

4. Numeric filter on Scorecard - Doesn't work

 

 

 

Numeric filters for Scorecards are not working

Explorer ✭ ✭ ☆
# 4
Explorer ✭ ✭ ☆

is count a dimension or measure ?, if it is measure, then when you place it in the scorecard it will sum automatically , the filter will apply to the total value regardless of the dimension type. 

 

if you show count> 14 , the filter will show no data.