11 Replies Latest reply on Feb 14, 2018 5:09 AM by Zhouyi Zhang

    count distinct status upon aggregation

    harshitha k

      Hi all,

       

      I have a calculated field  having the following calculation :

      { FIXED [ID] : SUM([VALUE]) }

      This returns the aggregate of all values of a particular ID. I also have a status(which contains either "A" or "B") corresponding to the ID. My problem is that I am not able to count the status(i.e number of status with value A, number of status with value B). Any help is deeply appreciated.

       

      Regards

      Harshitha