Hi! I want to count the number of responses for a form with Enum options "1", "2", "3". How could i write it in a formula? i.e. I want to count how many number responded "1", "2", etc. Hoping for replies.
Thank you.
Also, consider instead using a view's Grouping function. In a Table or Deck type view based on the table with the Enum column, select that column for the Group by property and then select "COUNT::{that column}" for the Group aggregate property.
User | Count |
---|---|
41 | |
30 | |
29 | |
16 | |
14 |