I have this cumulative sum query, which adds the number of entrances and exits in a building every 15 minutes:
![Screenshot from 2022-10-04 16-46-37.png Screenshot from 2022-10-04 16-46-37.png](https://community.qlik.com/t5/image/serverpage/image-id/90570i0FB34675F0C1B1A6/image-size/large?v=v2&px=999)
Which uses this query for the count:
rangesum( above( sum(forward_count2-backward_count2),0,rowno(TOTAL)))
How can I modify this query to return the highest value of this cumulative sum for each day? I would like to use the highest value as a measure in a bar chart.