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)
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.