Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
Let's say there is raw data with following columns:
Date, Metric ID, Metric Value
I need to create a result table with following columns:
Metric ID, Metric Value
In Metric Value column I need to show a value from max day each metric appeared.
What expression I need to use?
Thank you in advance
=FirstSortedValue([Metric Value],-Date)
=FirstSortedValue([Metric Value],-Date)