1 Reply Latest reply on Sep 30, 2013 2:19 PM by nick.stuchbery

# Help!!!   Problem with partitioning and totalling up a field as a percentage.

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

• ###### 1. Re: Help!!!   Problem with partitioning and totalling up a field as a percentage.

Sorry - I can't figure out to add the spreadsheet in, but the data is set  up exactly as below..;...