10 Replies Latest reply: Sep 29, 2016 2:13 AM by Paul Steinborn RSS

    Aggregation of Set Analysis

    Paul Steinborn

      Dear Community,

       

      i want to aggregate a set analyis like following:

       

      Get SUM of COUNTED VALUES that are GREATER THAN a VALUE_LIMIT AGGREGATED OVER VALUE_GROUP

       

      I tried follwoing without luck :

       

      SUM(AGGR(COUNT({<VALUE= {">$(= [VALUE_LIMIT])"}>} VALUE),VALUE_GROUP))

       

      I read a lot of topics about smiliar problems, but nothing helped me.

      Maybe the aggreagation should happen at a deeper level, inside the Set Analysis.

      Any idea how to solve this?