I need help creating a data-explorer query to list the number of times a field has been selected in a user select field. The example output would be for user_field_2 and how many times each option is selected (how many users select each option)
The output would be something like this:
Assume there are two options for this select field, Yes and No:
First time travelling amount of people using this field option
Yes 150
No 30