Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a filter titled ID. I need to chose the latest value on ID filter based on a maximum date.
My data set looks like this
Date ID
2022/12/17 3
2022/12/17 4
2022/12/17 5
2022/11/25 1
2022/11/25 9
So when the ID column is displayed on the table, I need to write a set analysis expression that it should always give dynamically the results.
In this case it should display 5 because 5 is the maximum value for ID since the maximum date is 2022.12.17.
How do I write set analysis? I tried many but didn't work
=Max({<Date={"$(=Max(Date))"}>}ID)
=Max({<Date={"$(=Max(Date))"}>}ID)
Thanks.