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:

       

      _idDimension2Dimension3Dimension4Dimension5Dimension6
      123valuevaluevalue
      456valuevaluevalue
      789valuevaluevaluevalue
      012valuevalue

       

      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?