4 Replies Latest reply on Feb 13, 2020 10:43 PM by Deepak Rai

    Convert Calculated Field to a Dimension

    Shelby Hodge

      Hi Team,

       

      I am struggling to find a solution - I want to convert the calculated field to a Dimension.

       

      I want to report on how many responses were  'Disengaged', 'Moderately Engaged' & 'Engaged' (these will be my 3 dimensions.

      {Engagement Score} is also a calculated field.

       

      IF (AVG([Engagement Score]) <= 3.4) THEN

          'Disengaged'

      ELSE

          IF (AVG([Engagement Score]) > 3.4 AND AVG([Engagement Score]) <= 4.4) THEN

              'Moderately Engaged'

          ELSE

              IF (AVG([Engagement Score]) > 4.4) THEN

                  'Highly Engaged'

              END

          END

      END

       

      Please help!

      - there is no option to right-click and convert to dimension

      - there is no option to drag from measure and drop into dimension.

       

      Thanks in advance