Data Studio
2.2K members online now
2.2K 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.