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
4.8K members online now
4.8K 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"

Participant ✭ ☆ ☆
# 2
Participant ✭ ☆ ☆

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.

Re: Dynamic date "Today"

Follower ✭ ✭ ☆
# 3
Follower ✭ ✭ ☆

Hi Kunal, Data Studio do not supports custom date ranges as on now. I am also trying to create calculations by defining date ranges using Today(). Hope we will get this function available soon.

Dynamic date "Today"

Follower ✭ ✭ ☆
# 4
Follower ✭ ✭ ☆

Yeah, thank you.

Dynamic date "Today"

[ Edited ]
Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

In my case, I was able to "discover" today. However, it's a case I believe not everyone will see use.

 

I just wanted to see how many sessions the website had in the quarter so far and how many it was tracking to, by the end of the quarter.

This will work with any given date range.

 

I used MAX(Day Index), named it "YesterdayIndex" and then made it a number. This is the difference of days from the start of your date range and today.

Then I used ROUND((Sessions / (YesterdayIndex + 1)) * 90, 0)  to get an approximation of how many sessions the website was tracking to be at in the quarter.

Roughly, I divided the number of sessions so far by the number of days so far and multiplied by 90 as the number of days in the quarter.

 

It's not exact and there might be some easier way to do it, but it worked for me.