10 Replies Latest reply: Mar 29, 2016 4:59 AM by Neil Deeley RSS

    Count if...

    Neil Deeley

      Hello,

       

      I'm successfully counting the number of alarms using set analysis to create a line chart:

       

      Count({$<Date={'>=$(=Date($(vTodaysDate)))'}, alarm_status={3}>} AlarmCount)

       

      My line chart has a fixed reference line showing all the alarms that are higher than a burst point of 12:

       

      Image1.png

       

      My manager now wants a count of where the alarms for a given date are above 12. I think I should be able to do this with a count if, but i can't get it to work:

       

      count(if(Count({$<Date={'>=$(=Date($(vTodaysDate)))'}, alarm_status={3}, DataSource={'Alarms'}>} AlarmCount) >12, AlarmCount)

       

      Any ideas on the syntax I should be using?

       

      Cheers

      Neil