How to filter on the last day with available data

[molly_lippsett]

Knowledge Drop

Last tested: Jun 5, 2020

Create a yesno dimension like this:

dimension: latest_date { type: yesno sql: ${created_date} = max(${created_date}) ;; }

Use this dimension, set to = Yes, as your UI filter