18 Replies Latest reply: Jan 26, 2016 2:19 PM by Adrian Lim RSS

    survey questions score and aggregation?

      Hel\lo!

       

      I had some help here for creating an inline load to map survey responses to numbers...

       

      the next part however is throwing me off...

       

      I have a set of survey responses, and each questions have a different number of responses..

       

       

      I'm trying to now show the avg for each question (eg - question 1 has an avg of 4.54 based on the formula ((37*5)+(19*4)+(2*3)+(1*1))/(37+19+2+1)

       

      but also I want to show the avg for all questions in each (section)

       

      When I try to do something like AVG(AGGR ( COUNT (DISTINCT surveyID) question), I get 2.0

       

      sample attached, hope someone can help!