Below is the data for my question. In this scenario, a child goes through a number of trials and is asked to choose a colour. Each trial number the choices are recorded per row. For example below, in Trial One Karen chose red first (a distinct row), then Green, then Blue. Using the First() is true filter I can create a list that shows example 2
The Problem: I need to show a graph or table that displays the total % of each colour as the first choice. From the data below, Red = 50% of first choices, Green = 10 % and Blue 40%.
I cannot figure out how to get all of the data in the different partitions to roll into one so I can give the aggregate % of each choice.
row shelf has Name, Trial#,Choice as fields.
Example 1
Name | Trial Number | Choice | ||||||||
Question? | ||||||||||
Karen | 1 | Red | <-------First() | What is the percentage of each color as First choice overall? | ||||||
1 | Green | |||||||||
1 | Blue | |||||||||
2 | Green | <-------First() | ||||||||
2 | Blue | |||||||||
3 | Red | <-------First() | ||||||||
3 | Green | |||||||||
3 | Blue | |||||||||
Nick | 1 | Blue | <-------First() | |||||||
1 | Green | |||||||||
2 | Red | <-------First() | ||||||||
2 | Blue | |||||||||
2 | Green | |||||||||
3 | Blue | <-------First() | ||||||||
3 | Red | |||||||||
4 | Red | <-------First() | ||||||||
4 | Blue | |||||||||
4 | Green | |||||||||
Keith | 1 | Red | <-------First() | |||||||
1 | Green | |||||||||
2 | Blue | <-------First() | ||||||||
2 | Green | |||||||||
3 | Blue | <-------First() | ||||||||
3 | Green |
Example 2
Name | Trial Number | Choice |
Karen | 1 | Red |
2 | Green | |
3 | Red | |
Nick | 1 | Blue |
2 | Red | |
3 | Blue | |
4 | Red | |
Keith | 1 | Red |
2 | Blue | |
3 | Blue |
Sorry - I can't figure out to add the spreadsheet in, but the data is set up exactly as below..;...