Question

Display only values with the latest date by State

  • 23 September 2021
  • 0 replies
  • 20 views

My data is formatted like so:

State, weather, dt

California, sunny, 9/23/21

California, rainy, 2/22/20

California, foggy, 1/16/19

 

 

How can I only display the entire record with the latest date? In this case, after selecting Run, 

California, sunny, 9/23/21 is displayed. 

 

There are many states and weathers, but only 1 record per each state and day. 

Thanks! This is my second day playing around in Looker, so excuse the naivety to the question.


This topic has been closed for comments