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
1.4K members online now
1.4K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Feature Request: Using dates selected in calculations

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

Hi

 

If this is possible I'd love to know, otherwise it would be great to have as a feature.

 

I currently have several reports containing metrics where I need to use the number of days selected within the calculation.

 

E.g. If a week is selected, the metric is 7 times higher than it should be and therefore it would be useful if the dates selected (start date and end date) were useable within calculation - e.g. datediff() to help aggregate results.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Robert L
March 2017

Feature Request: Using dates selected in calculations

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

Ansswered my own question. I found the "Count distinct" calculation when clicking on the date variable which creates a calculated metric which you can use in your calculation.

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Robert L
March 2017

Feature Request: Using dates selected in calculations

Follower ✭ ✭ ☆
# 2
Follower ✭ ✭ ☆

Ansswered my own question. I found the "Count distinct" calculation when clicking on the date variable which creates a calculated metric which you can use in your calculation.