2 Replies Latest reply on Feb 29, 2016 3:00 AM by Matthew Sleight

    Calculated Field: % of Responses that are Positive in a Survey

    Matthew Sleight

      Hi All,

       

      I have a Vis to investigate the results of a surveymonkey empoyee engagement survey.  The results of the survey include a field called 'Mood' which can be either 'Great', 'Good', 'Not So Good' and 'Terrible'.

       

      I have a calculated field that gives my whether a response is positive (Great/Good) or negative.

       

      I then use a table calculation to display the percentage of positive and negative responses for each location and business unit.

       

      What I want to do now, is to show the change from a baseline month.  The trouble is, I think I need to have a calculated field giving the % of positive responses, and I cant figure out how I would do that.

       

      Any advice would be appreciated.  I'm certain I can show the month on month change easily once I have that calculated field.

       

      Cheers