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

Can't filter out certain days of the week

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I've created a custom field in my report on Search Console data and am trying to create a date filter control to filter on days of the week. This works for Table data but doesn't work on any graph with Date as the dimension. The graph just disappears, as if the data got corrupted.

 

Screen Shot 2017-02-24 at 10.13.32 AM.png

 

Here's my calculated field:

Screen Shot 2017-02-24 at 10.14.36 AM.png

 

Thanks!

Can't filter out certain days of the week

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

Rather than doing it from your data source, try clicking on your chart and creating a filter. You can tell it to exclude any dimension (weekday) that equals a specific value. You just need to make sure that you're entering it in the way your data is on the back-end (is Sunday represented as "Sunday" or as "1"?). 

Can't filter out certain days of the week

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

That works but I'm looking for the ability to do so using those controls, so someone else could come to the report and play around with it.