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

    survey questions score and aggregation?



      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!