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

Using date range controller dates in calculated metrics

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi all,

 

Is there a way to use the date range that the user has selected in a date range controller as a variable in a calculated metric? I want to display the average number of sessions per day given the selected date range in a scorecard. I was thinking 'Sessions/DATE_DIF('FIRST DATE OF DATE RANGE','LAST DATE OF DATE RANGE'), but am not sure how to fetch that data, if it's even possible. I'm open to alternative solutions. Thanks!

 

-Ian Tremblay

Using date range controller dates in calculated metrics

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

Hi Cascade,

 

as written in the Google Data Studio FAQ, Variables are currently not supported.

 

"[...] data displayed in a report must be derived from a chart's dimensions and/or metrics. There is no way to display singular text values derived from the data source." 

 

 

But since there is an answer for that question, I guess at some point in the future we'll get this feature.

 

Best Regards!