7 Replies Latest reply: Mar 22, 2016 11:54 AM by Sunny Talwar RSS

    max count as a reference line

    Neil Deeley



      I'm trying to add the max count of alarms over 10 mins intervals as a reference line for a line chart. My user just wants to show the highest value on a chart whatever the selection.


      My chart has the count of alarms by Ten minute interval and Date


      I'm using the expression max(aggr(count({<DataSource={'Alarms'}>} AlarmCount), TenMinInterval)).


      This works if I select an individual day from my date range:




      However, if I select more than one day the highest value is no longer shown:



      The value 249 should be the highest value in the chart, but instead its 312.


      Any idea what i am doing wrong?