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