This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a set of survey responses with 10 questions where the customer could select one of six responses. I need to calculate the percentage of responses that equal 'Agree' or 'Strongly Agree'.
Here (and attached) is an example of what my data looks like:
I was able to count the sum of each answer and then make a formula that added together the percentage of Agree and Strongly Agree for the entire data set, but the data will need to also be matched to Client and Sector so I need to be able to factor in the RecordID and I'm not nearly advanced enough to come up with how to do that.
Hoping someone can help a beginner here who is struggling!
I think the output can be quite simple, because I will append it to my main workflow, so something like this, where each Record ID has a corresponding percentage of people who answered 'Agree' or 'Strongly Agree' to the 10 questions.
It has worked! I had to make a minor adjustment as my actual data was calculating the questions into the 'All Responses' column (which could have just been my error in re-purposing the workflow into my existing workflow...) but I've got the answers I need.
Thank you so much for your help, you've saved me so much time and frustration!