8 Replies Latest reply on Aug 7, 2018 2:14 PM by Jaya Sinnathamby

    LOD For Survey Question using Likert Scale

    Jaya Sinnathamby

      A very common question in surveys is level of satisfaction type question with a response scale of 1-5.

       

      I want to show the Average Score for a question, aggregated at a higher level side by side with the detail score, but I'm unable to come up with the right LOD calculation.

       

      So I want to go from here showing the Average Score for each city:

       

        

      Avg Score
      MDBaltimore20173.0
      20183.0
      Bowie20171.5
      20183.7
      Towson20172.5
      20184.0
      VAAlexandria20173.5
      20182.7
      Arlington20174.0
      20183.0
      Richmond20172.0
      20183.3

       

       

      to here showing the Avg Score by State as well as Year in the same chart.

       

      Thanks, JayaLOD1.jpg

       

      Ver 2018.1