Finding a percentage from survey data

Topic Labels: Formulas
491 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer


Not sure what formulas/table configuration I should be using here. I have a table of responses to pre and post-program surveys and want to be able to compare the responses to the pre to those of the post (See image below).

Screen Shot 2021-05-26 at 1.04.22 PM

For each question in the survey, I would like to know the following:

  1. how many people responded with each answer for each survey (ie: 8 people said they weren’t at all excited in the pre-survey but only two said they weren’t at all excited in the post-survey).
  2. The percent of people who responded with each answer only out of those who answered that particular question.

I know this will most likely involve linking records and rollup fields in a separate table but I have been trying to figure this out and nothing has been working. Any and all suggestions would be so helpful.

0 Replies 0