Max value from running total graph

[anseglko]

I have a line graph with timestamp as a dimension and population as a measure. The measure is calculated with

rangesum(above(sum(if(floor=1,people_in-people_out)),0,rowno()))
/count(distinct entry_date)

It sums all the people coming in and subtracts people going out. This is divided by all days to get the daily average (there might be a better way to do this too)

The graph is correct and looks like this:

I need to show the maximum value of the day in a KPI, so in this case 278. How is this done? 

[jheasley]

try a max(aggr(YOUR ORIGINAL EXPRESSION HERE))

[anseglko · Accepted solution]

I revisited this problem and finally found a solution that works

=Max(Aggr(rangesum(above(Sum(if(floor=1,people_in-people_out)),0,rowno()))
/count(distinct entry_date),(entry_hour,(NUMERIC))))

I had tried max aggr before but now it finally worked with the (NUMERIC) added.