How to filter on the last day with available data

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

This content is subject to limited support.                

Version history
Last update:
‎06-28-2021 11:49 AM
Updated by: