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