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.

    nick.stuchbery

      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

       

       

      NameTrial NumberChoice
      Question?
      Karen1Red <-------First()What is the percentage of each color as First choice overall?
      1Green
      1Blue
      2Green<-------First()
      2Blue
      3Red <-------First()
      3Green
      3Blue
      Nick1Blue<-------First()
      1Green
      2Red <-------First()
      2Blue
      2Green
      3Blue<-------First()
      3Red
      4Red <-------First()
      4Blue
      4Green
      Keith1Red <-------First()
      1Green
      2Blue<-------First()
      2Green
      3Blue<-------First()
      3Green

       

       

       

       

       

       

      Example 2

       

       

      NameTrial NumberChoice
      Karen1Red
      2Green
      3Red
      Nick1Blue
      2Red
      3Blue
      4Red
      Keith1Red
      2Blue
      3Blue