Finding maximum value - Cumulative Calculation

[EliGohar]

Hi All,

I'm having this table with the following data:

The table presents data of Entering vs. Exiting people by date and hour.

I want to create KPI that finds the max value for a specific date from my cumulative expression (in the above example, the max is 403).

I tried this expression:

=max(aggr(rangesum( above( count({<[Class Category ID]={0}, [Path & Area]={'Entering'}>} ObjectID),0,rowno()))- 
rangesum( above( count({<[Class Category ID]={0}, [Path & Area]={'Exiting'}>} ObjectID),0,rowno())),Date,[Hour (hh)]))

But I got wrong value.

Please assist me with the correct expression.

Thanks,

Eli.

[EliGohar]

@Ksrinivasan Peek function can be used only from the script.

I'm looking for a solution within the client (Dashboards).

[Anil_Babu_Samineni]

To build up your dashboard is again work for us, rather load the data and share in QVW or QVF so that we will do quicker and will try our best