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

Calculate Remaining days

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi there everyone,

Just curious if it's possible to have a custom calculated field that presents the number of days remaining? I'd love it if there was an alternative to having to use gsheets to calculate it...

 

Many thanks, 
Arnaud BB

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Arnaud B
June

Calculate Remaining days

Explorer ✭ ✭ ✭
# 4
Explorer ✭ ✭ ✭

To my knowledge not natively in Data Studio because you can't calculate dynamic dates like Today() for instance.

 

Using another data source like a Google Sheet is the only way I'm aware of currently.

View solution in original post

Calculate Remaining days

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

Need a little more context, are you trying to calculate remaining days in a week, month, dataset entirely?  If you're trying to calculate remaining days in a date range, I don't think you can do this natively in DS because you can't calculate Today() without using a Gsheet currently.

Calculate Remaining days

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi there Mike,
I was hoping to be able to calculate remaining days in quarter ideally seeing as thats already a set option available.

Is that possible at all?

Thanks

Marked as Best Answer.
Solution
Accepted by topic author Arnaud B
June

Calculate Remaining days

Explorer ✭ ✭ ✭
# 4
Explorer ✭ ✭ ✭

To my knowledge not natively in Data Studio because you can't calculate dynamic dates like Today() for instance.

 

Using another data source like a Google Sheet is the only way I'm aware of currently.