Hi all, Curious if there is a way to return the “latest” date available? Or to filter by that? For instance, I have a dataset called “holdings”, and there is a linked “holdings date” (suppose I have just three dates 2024-08-01, 2024-08-10, 2024-08-23.) how can I just show the most recent date is 2024-08-23?

Hi Alex, This should be achievable with MAX function in MAQL. Please refer to the below documentation examples which should give you what you need: https://www.gooddata.com/docs/cloud/create-metrics/maql/aggregation/max/#MAX-Examples

That worked perfectly thank you @Julius Kos !