2 Replies Latest reply on Oct 16, 2018 9:27 AM by Deepak Rai

    How to count the occurrence of a certain value/ Changing from Dimensions to Measures

    sabari.shrestha.0

      Hi, I am trying to change the calculated field which is Measure to Dimension. I could not figure out to change the field to Dimension. I tried to drag to Dimensions and convert to Discrete.

       

      I want the discrete count of the number of occurrence of each value from the calculated field..

       

      I calculated a field called "1. Counts before donating highest" which counts the number of time a person (User ID) donated before he made his highest donation. I feel I get the calculation but I am not being able to change the Measures to Dimensions. I want the discrete count of each occurrence. In my example, I want to return the count of occurrence of 0 = 10, 1 = 9,2 = 1 and so on..