2 Replies Latest reply on Oct 18, 2018 2:43 PM by Paul Newell

    Count Occurrence of Dimension with Value

    Paul Newell

      I want to count the number of times each dimension has a value for ALL dimensions.


      So if I have the following table:




      I want a bar chart like this:


      TOTAL ROWS: 4

      Dimension2: 4

      Dimension3: 2

      Dimension4: 2

      Dimension5: 2

      Dimension6: 2


      The issues is that I have over 80 Dimensions, so I am trying to avoid manually make a calc for each. Is there a way to bulk achieve this for all dimensions?