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

    max count as a reference line

    Neil Deeley

      Hi,

       

      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:

       

      img1.png

       

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

       

      35082668875b4752b7910c175b382cbf.png

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

       

      Any idea what i am doing wrong?

       

      Cheers

      Neil