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!
Solved! Go to Solution.
Could you attach a screenshot of the expected output based on the attached input?
Regards,
Shreyansh Rathod
Hi,
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!