5 Replies Latest reply on Oct 23, 2019 8:50 AM by Diego Parker

    Adding Missing Survey Answer as 0

    Mahesh Gujar

      Hi Team,


      We're trying to create a survey analysis, wherein we want to add missing answers responses as 0 to calculate percentage of total.


      For e.g.

      In attached workbook you'll see 3 questions, it is a survey data wherein user have to rate the chat out of 1/2/3/4/5 and we want to see user rating percentage for that particular question.


      For 1st question, user have rated 1,2,3 and 5, but to calculate correct percent of total we would have to consider rating (answer) 4 as 0.


      Similarly, for 2nd question user ratings are 1,2,4,5 and here we have to add rating (answer) 3 as 0.


      Question no 3, is an ideal case where user have given ratings as 1,2,3,4,5 and we don't need to do anything just calculate percent of total for that particular question.


      Your help is much appreciated, thanking you in advance.


      Thank you!!