Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying only to show the most recent timestamp.
As you are using the location as a dimension, you are getting the Last time updated per trailer and location combination.
If you just asked for the Last time updated per trailer and then matched that for the location you may get what you want.
Dimension: Trailer #
Measures: Last Time updated = Max(updated_at)
Most recent location = only({<updated_at={'$(=Max(updated_at)'}>}current_location)
When I try that it shows a null value
This worked
firstsortedvalue([current_location], -[updated_at])