2 Replies Latest reply: Oct 19, 2017 8:57 PM by Cameron Vine RSS

    Count and aggregation of variable for the day

    Cameron Vine

      So I need to assess if a breach has occurred or not occurred on a day. There are a number of variables processed each day, if only one of them Breaches I need to count that as the breach for the day, ie. 1. It is a binary solution, if it is not a breach it must have been ontime. What I attempted to do with the formula is find the minimum of minutes for the day based on the unique ID which is the feedId, and if less than 0, Breach, if not Ontime.


      Count(

      aggr(

            if(           

                    min(Total <Status,Category> Minutes)<0,'Breach','Ontime'

                   )           

                  ,Status,Category,Minutes

               ) 

          )


      In the screenshot below the Count for day should be 1 for Breach and 0 for Ontime

      Capture.PNG