How to get most recent value from a data source?[ Edited ]
February 2017 - last edited February 2017
I have a Google Sheet configured as a data source. Column A in the sheet is a datestamp and column B is a metric. Rows are added to the sheet automatically every five minutes.
I'd like to use the Scorecard widget to display the most most recent value, ie the last row in the sheet or the metric that corresponds to the max datestamp in the data set. Is there a way to do this?
How to get most recent value from a data source?
I was trying to do this a while back but couldn't make it work with a scorecard. What I ended up doing is using a table. I pulled in the metric/dimension I wanted, sorted it so the most recent appeared on top, and then shrunk the table size down until only that first (most recent one) was visible. Not as pretty as a scorecard, but works until there's a better solution.