1 Reply Latest reply: Nov 18, 2011 8:50 AM by timtimtim RSS

    Scaling to 100% : two dimensions / one expression

      Hello all,

       

       

      It sounds easy, however I am not able to find the right solution.

      I have go a table who looks like this (simplification):

       

      Time             Recognition

       

      7                       YES
      7                       YES
      7                       YES

      7                       NO

      8                       NO

      8                       NO

       

       

      TIME and RECOGNITION are the dimension and ANSWER is the expression =count(Recognition).

      What I want to see is the distribution indexed to 100% for EACH moment in TIME (7 and 8).

      If I thickbox RELATIVE and adjust the Axe maximum to 1 I get what I show here beneath.

       

      Schermafbeelding 2011-11-18 om 14.08.51.png===>  Schermafbeelding 2011-11-18 om 14.11.37.png

       

       

      However, That is not what i need. The total for EACH moment in time needs to be 100%, not the combination of the two moments in TIME.

      I have been thinking about this all day by now. It drives me crazy.

       

      If you can help me with this, you are my hero.

       

       

      Kinds regards,

      Tim