5 Replies Latest reply: Sep 3, 2012 10:36 AM by yamazaki RSS

    count + aggr + sum ?

      Hello everyone,

      How are you all doing?

      Well, I need a help on that thing

       

      Here are the data :

       

      id; A; B ; C; D

      Dwayne; 1512,0,1325, 3125

      Derrick; 0,0,1541,3125

      Kobey, 0,5264,1254,3125

      Dwight;12;45;65;3125

       

      So, I need to count the id which have (A + B +C ) > 30% of D to put in a jauge.

       

      I think, I 'll need something like : aggr(sum(A) ,sum(A),sum(C), id)>(0.3*D)

      But I don't really  know how to handle that.

       

       

      I 'll be glad to have your point of view on that question.

       

      Wish you all the best,

      Will