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

Get the most recent date

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi everyone, I was hoping someone could help. Basically what I want is to show the value of a metric off the most recent date in the dataset. I tried MAX(Date) but unfortunately it did not work. 

 

This was my formula: SELECT Value1 WHERE Date  = MAX(Date)

 

Any help will be appreciated!

 

Thanks in advance

Get the most recent date

Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I've been looking to do something similar but haven't found a way in GDS. My backup plan is a second sheet in Spreadsheets where I use ifs and vlookups to filter my data the way I want.

Get the most recent date

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

I tried to do something similar to show the latest date of import. My quick solution was to add a simple table to return max date diff: MAX(DATE_DIFF(Day, Day)), giving me a table of two rows, earliest and latest date. Further I changed colours to transparent or white and minimised the entire table to only show the latest date.

 

You can do the same and the metrics you want.