Max timestamp value should display

[Rajesh]

Hi All,

I am trying to display  max timestamp data values in table

expression used: =Sum({<Duration={">20"},Date={"$(=Max(Date))"}>}Duration) displaying like below screen shot

need to get only highlighted data out put 

can any one suggest the solution

Thanks

Rajesh

[shiveshsingh]

Hi

What is the logic to show highlighted values?

Thanks

[Rajesh]

i would like to have only max timestamp value(Duration)

ex: on 21.07 8.00 AM its showing Duration 37

21.02  20.00 PM its showing Duration 34 

need to show only one max timestamp data.

Thanks

Rajesh

[shiveshsingh]

On what basis you are calculating the maximum duration? Your workflow and instance have same values for all the timestamp, 

On Daily basis? can you share some sample?

[Rajesh]

please find attached app

the highlighted data is summing up on that day duration instead i want max(timestamp data) its should show 34(duration on 21.07 20.00PM data as previous inserted image)