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

Excluding current week/month

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

When playing with Date Ranges it would super if you could choose something like this: "Last X weeks (Mon-Sun) (excluding current week)" . 

 

Also when doing year wide comparison the possibility to exclude "this week" would make my line charts look a lot better. 

 

This kind of problems easily occur when bringing data straight from Google Analytics.

Excluding current week/month

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

 

I have the same problem. Visualizing the current year, every line drops to the bottom an rises at the end of year (no clue why)..

Excluding current week/month

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Raising this thread, since I also have trouble with this.

Excluding current (unfinished) period would be necessary. 

 

Date comparison for bar charts would also be desirable (to previous period/year)

Excluding current week/month

Follower ✭ ☆ ☆
# 4
Follower ✭ ☆ ☆

Same problem here if using month of the year, the line drops always while it's going to be a new month. 

 

Can't find a way to exclude current month.

Excluding current week/month

Follower ✭ ☆ ☆
# 5
Follower ✭ ☆ ☆

Same problem. Would be great to exclude the current month.

Excluding current week/month

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Same issue.. Has anyone found a work around for this issue?

Excluding current week/month

Visitor ✭ ✭ ✭
# 7
Visitor ✭ ✭ ✭

Bumping this thread as this functionality would be very useful to me too! 

Re: Excluding current week/month

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

The only way I have found around this is to add a time series filter to the chart which excludes the current month. It's not ideal but works and makes the charts look better.

Untitled-1.png