I have a content type with 6 select-list fields. Each field has several available values, multiple selections allowed via checkboxes. A group of users each submit the content once.
Select List Field 1
user001 answered | user002 answered |user003 answered 1|oranges | 1|oranges (x) | 1|oranges (x) 2|apples (x) | 2|apples (x) | 2|apples 3|bananas (x) | 3|bananas | 3|bananas 4|mangos | 4|mangos (x) | 4|mangos (x)
Select List Field 2
user001 answered | user002 answered |user003 answered 1|eggs | 1|eggs (x) | 1|eggs (x) 2|fish (x) | 2|fish (x) | 2|fish (x) 3|nuts (x) | 3|nuts | 3|nuts 4|berries | 4|berrries (x) | 4|berries (x)
Views, showing Content of type, contextually filtering on the group id, displays selections from each user in the group. A list of all selected values is shown, including many duplicates.
Instead of showing this list (above), I would like to display the number of times each value was selected in total by that group of users.
Fish (3) Apples (2) Berries (2) Eggs (2) Mangos (2) Oranges (2) Bananas (1) Nuts (1)
I have tried Views aggregation, but so far have only been able to count how many values were chosen for a given field, instead of counting how many times each specific value was selected.
It seems like this should be easy to accomplish, like I am missing something simple. How can I achieve this?