7 Replies Latest reply: Jul 4, 2016 2:01 PM by Manish Kachhia RSS

    Comparing average with the field

    Ankit Tr

      Hi,
      I have following data sample:


      ID    Category    Value      Flag

        x         A                12      Chosen

        x         B                10      Cancelled

        x         C                 5      Converted

       

       

      I need to compare average value (on id level) with that of value of category with 'Chosen' Flag

      The output I need is this:

       

      ID       Category         Value   Average Value

      x             A                  12         9 (Average of 12,10 and 5)

       

      I tried applying filter (Flag=Chosen), and ruled it out while calculating average. But, that does not seem to work:


      avg({$<[Category]=,[Flag]=>}[Value])

       

      This would ignore Category and Flag while calculating the average.