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.
Thank you very much! Mission accomplished