How to create a Data View that counts only 'yes' responses

Owned by Mary Lukowski
Last updated: Jul 25, 2014Version comment
1 min read

Overview

A categorical variable with pick list options of No and Yes can be summarized in a data view with the aggregate method of 'count'.  The result will show a count of how many subjects answered 'yes' and how many subjects answered 'no'.

 

Alternately, it may be desired to only show how many subjects answered 'yes'.  If the pick list options were set up with a value of 0 = No and a value of 1 = Yes, then in the data view use an aggregate method of 'sum'.  

If the values are not 0/No and 1/Yes, then the variables can be recoded in the data set.