Dear Dimitri, thank you very much for your kind and prompt advise!

I twisted your suggestion a little bit and I got the following results:

The Tableau Public file is shared :

http://public.tableausoftware.com/views/histogram_04/Sheet3?:embed=y

The cummulative frequency distribution is created according to :

http://kb.tableausoftware.com/articles/knowledgebase/cumulative-distributions

Hi, Dimitri, you advise is clear and I'm to be blamed for not explaining my intention clearly.

I'd like to hear your advices again:

Still referring to the same data set, I want to calculate the % of people who is satisfied (satisfaction=1) for each brightness band. (without using the satisfaction groups created this time)

e.g. in the chart shown below which is a frequency distribution for the 8 brightness value bands (5-10, 10-15, ...) for all the cases

I'd like to create a chart with its x axis being the same as the one shown above, but with the y axis being the % of people whose satisfaction value is 1 for each brightness band or bin.

i.e. currently, there are 10 person (4.02%) whose brightness values are <=10, and among these 10 people 4 have a satisfaction value of 1, so the y axis value for the "5" brightness band should be 40% (4/10). Similarly, there are 46 (18.47%) people with a brightness <=15, and among these 46 people there are 25 with satisfaction of 1, so the y axis value for the "10" brightness band should be 54.35% (25/47), etc...

I've played with the table calculation function a bit, but still don't quite get it ...

May I ask how to achieve this?

The base chart is shown here:

http://public.tableausoftware.com/views/histogram_07/Sheet2?:embed=y

The Tableau Public workbook file is attached as well.

Thanks again!

- J

Hi, Dimitri, thank you!

I've explored a bit and pls kindly review the charts created and the annotations from chart 01 to 08 explaining the approach:

http://public.tableausoftware.com/views/histogram_08/08?:embed=y

Wish you a great holiday!

- J