Display only values with the latest date by State

  • 23 September 2021
  • 0 replies

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