Showing incorrect status

[#1]

Hi all,

I have a straight table, which show a status relating to an Order.

I'd like to just show the most up-to-date Action Status per order, but in my case it isn't reflecting this.

I've used an aggr expression to get the latest Creation Timestamp, which seems to work just fine. But using the Action Status as a dimension, it doesn't return

the latest Action Status???

I 've attached a sample .qvw of what I'm trying to achieve.

If you have any ideas as to what I'm doing wrong or missing, I'd like to hear your thoughts.

Many thanks

[tresesco]

Hello,

Your CreationTimeStamp  is being read as TEXT that is why QV is not beaing able to understand the max/min. You have to correct that while it is beaing loaded. And then you can try FirstSortedValue  function to achieve the same easily.

Thanks.

[#3 · Accepted solution]

You may try attached application.....

[#4]

you may also look at this one...which is built using firstSortedValue as an expression as guided by tresesco