Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
===>
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
I found it myself after a good and strong coffee.
Today my hero is me.
=count(Recognition ) / count(TOTAL <Time> Recognition)