How do i count the number of times I get a yes and also the percentage of yes responses

[DemiDavid]

Hello,

For context, I am trying to create a form that can a company if they are compliant based on their Yes/No response to a series of questions I am capturing in a table.

So I am trying to do things :

1 Count the number of ‘Yes’ responses
2 Calculate the percentage of the responses that are ‘Yes’

I’ve been reading the forums and googling for the past 3 hours and I still can’t figure out how to do this, it seems like a simple but I can’t seem to figure this out it’s.

My table has about 200 columns in it so it’s difficult to screenshot.

[kyleheney]

1. IF-THEN column — if Yes, TRUE (this creates a Boolean column of responses)
2. Roll-up column that looks at the boolean column – count true
3. Roll-up column that looks at the boolean column – count all; Math column to calculate percentage looking at the true count vs the all count.

[DemiDavid]

Thanks for the response much appreciated.

I’m using the IF THEN ELSE but it doesn’t seem to be working am I doing it right?

[Jeff_Hager]

What’s not working??? I see a row with a column that has ‘1YY’ which is one of the conditions you are checking for in your IF column and the result of the IF column is a boolean value that is True/Checked. Seems like it’s doing what it’s supposed to be doing.

[DemiDavid]

I think the problem with this solution is its counting the frequency of ‘’1YY’ in the column when I want it to count the frequency of ‘1YY’ across the row.

If I understand correctly, each row is a form submission, I want to count within that submission how many times ‘1YY’ has been selected.

What currently seems to be happening is ‘1YY’ is being counted across all the form submissions which is not my intended outcome.

[Jeff_Hager]

OK, if you want to count the number of occurances in the same row, then what you need to do is create a Make Array column to join all of your other column values into an array, and then create a Rollup column that counts the number of elements in the array.

[DemiDavid]

Thanks! But I think one thing missing from this solution is some kind of filter or if statement. From what I can see the array accepts whatever is in the column but on my form a person can answer 1YY or 1NN.

I want to calculate a percentage of the responses how many times the responded chose 1YY (which would be 1YY/ TOTAL RESPONSES = PERCENTAGE OF 1YY RESPONSES)

Sorry If I’m not explaining this clearly

[Darren_Murphy]

Use a remove multiple elements column to remove 1YY from the make array column. Then you can work from there…

[DemiDavid]

Perfect thanks so much for your help @Darren_Murphy and @Jeff_Hager !!!