Dynamic Date Filter

How can I create a custom date filter to show the latest available date only? For example: max({avail_calendar_date})

Hi Robert!
You can create a calculated field maxOver({your date field}, [ ], PRE_AGG) to get the max date in your data. If you are looking to apply a filter for only records of your latest date. You could use a Top/Bottom filter on your date value and select top 1 for value of date field aggregation max. (see screenshot)

2 Likes

Hi Kellie,
Iā€™m sorry, for the slow response. Thank you for taking the time to respond to my question. Your solution is perfect for my scenario. Thanks.