Finsding status from higer timestamp

[#1]

Hi

This might be a quite a simple expression for the people here , i am trying to find the status of the each request , with higher time stamp , attached my application , can some one help me in figuring the mistake i am making in my expression.

Thanks!

[#2]

Hey,

You just needed to convert the timestamp into a human-readable format to compare with Status Date:

only({$<[Status Date]={'$(=(Timestamp(max([Status Date]))))'}>} srsh_status)

Hope this helps!

[#3]

for some reason the above expression did not work , i used below and it worked ..

only(if(srsh_status_dt=aggr(nodistinct max(srsh_status_dt),SR_ID),srsh_status))

[#4]

Hi

I suggest a more simple way, use FirstSortedValue

In you case create a chart with

Dimension :   Stocket Request #

Expression :  FirstSortedValue( srsh_status ,-[Status Date])   I use '-' to find the higher date

Regards

JJ

[#5]

this should help

aggr(FirstSortedValue(srsh_status,  - [Status Date]), [Socket Request #])