filter on latest date from the table

[vaishnavig]

I want to apply latest date filter in where clause of my explore but its not working. I tried using below code

explore: ci_details_item_location {
from: ci_base_ads
sql_always_where:load_dt=max(load_dt) ;;
}

could you please help me with the same

[GavinW]

Perhaps sql_always_having is what you need here?

[vaishnavig]

yes. I am trying to filter on latest data