Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!
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))
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
this should help
aggr(FirstSortedValue(srsh_status, - [Status Date]), [Socket Request #])