Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
try a max(aggr(YOUR ORIGINAL EXPRESSION HERE))
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.