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

    Count if...

    Neil Deeley



      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:




      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?