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

Exclude Weekends from Time Series

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Is it possible to exclude weekends from a time series report in the visualizations? I know you can filter to exclude the data, but is it actually possible to just delete those placeholders out of the sheet? For example of I have data that overlaps from one week to the next but zero or null values, the time series line charts drop to 0 making it look off. 

Exclude Weekends from Time Series

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

You should be able to use a filter to exclude the weekend days, so they won't show up on your chart.

Exclude Weekends from Time Series

Follower ✭ ☆ ☆
# 3
Follower ✭ ☆ ☆

I can't get this to work when I'm using 'Date'. Seems I have to be using 'Day of week' to filter out Saturday or Sunday. 

Exclude Weekends from Time Series

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

I'm interested in this too, please let me know if you found the answer

Exclude Weekends from Time Series

Follower ✭ ✭ ☆
# 5
Follower ✭ ✭ ☆

Add a calculated field something like WEEKDAY(date_field)

 

Then create a filter on the chart excluding the weekend days.

Exclude Weekends from Time Series

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Didn`t quite work for me. I'm using a time series and the graph will still display Saturdays and Sundays, just without data. Would be nice if those where just left out completely