Tracking total responses to yes/no questions

In my app, I have a yes/no response in each section. It is all tracked in one column of data. How am I able to track the. Total “yes” and “no” answers?
It is easy to add numbers up in a column and get total, but how do I do this with alpha columns?

You can do a relation to return all the Yes and make a rollup to count the number of Yes answers.

Thank you. Excuse my lack of understanding, but what does that mean?

You can follow the steps below:

  • Create a template column with the word “Yes”.

  • Make a relation matching that template column with your answers column, return multiple matches.

  • Create a rollup column, take value from the relation and set the calculation to count.

Follow the same process for “No”. I imagine it would be the same.

The other way to do this would be through a chart component, if you don’t mind a chart I think it would be easier.

1 Like

Thank you very much! Mission accomplished

1 Like