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

Dynamic date "Today"

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

Hello Team,

I have time series chart which displays monthly data, however I need to show data in chart only till current month. I don't see any function called today() in order to capture current month. Please see below screen shot, for now I have added filter called Month filter (but its hard coded) as 201706, Can we have dynamic date function here? Or what can be the alternate solution to see data till current month?

11.JPG22.JPG

 

Similarly, I want to display another chart with data from next month to Dec 2017. For e.g. June 2017 to Dec 2017. I have data for these months too. 

 

 

Dynamic date "Today"

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Nothing exists in DS to let you do these calculations to my knowledge.  You may be able to ,if at all possible, insert the common timeframe calculations you need into your Google Sheet datasource so that you can filter on them.