10 Replies Latest reply: Oct 26, 2017 1:18 PM by GE US Enterprise Solutions RSS

    Set Analysis Help Needed

    GE US Enterprise Solutions

      Hi!

       

      I am working on creating a set analysis expression and need some help or pointers from the experts.

       

      1. I calculate a number, using the following expression: =avg(aggr(sum(IB_COUNTER),[%ENCRYPTED_NAME], [%IB_DEVICE_TYPE]))

       

      2. What I wan to do next is calculate a MAX((aggr(sum(IB_COUNTER),[%ENCRYPTED_NAME], [%IB_DEVICE_TYPE])), but only for the values that meet the following criteria:

      =fabs(Sum(TOTAL<[%IB_DEVICE_TYPE]> IB_COUNTER) / COUNT(TOTAL<[%IB_DEVICE_TYPE]> DISTINCT [%ENCRYPTED_NAME]) - avg(aggr(sum(IB_COUNTER),[%ENCRYPTED_NAME], [%IB_DEVICE_TYPE]))) > $(vOutliersThreshold) * Stdev(TOTAL<[%IB_DEVICE_TYPE]> Aggr(Sum(IB_COUNTER) ,[%IB_DEVICE_TYPE],[%ENCRYPTED_NAME]))



      I think this could be done using indirect set analysis, but I am struggling with constructing the right expression.


      GREATLY APPRECIATE ANY HELP!!