See attached (doesn't look like your example, but that's what the data says).
The steps are:
- Create 'brightness' bins (right-click -> Create Bins...)
- Group 'satisfaction' scores into positive and negative (right-click -> Create Group...)
- Build a graph as laid out in the attached
- Set 'quick table calculation' for SUM(Number of Records) to Percent of Total (click little down arrow on the right of the 'pill'), then set 'Compute using' to 'satisfaction (group) '
- Hide negative section of the graph (right-click -> 'Hide')
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 :
The cummulative frequency distribution is created according to :
I see, you wanted % of each bucket, but only for positive satisfaction. There is always a danger of misreading intent while reverse-engineering the desired output.
I am glad it worked in the end.
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:
The Tableau Public workbook file is attached as well.
histogram_07.twbx.zip 39.8 KB
Joe, we have public holiday on Wed, I will try to take a look after that (unless someone chips in before then).
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:
Wish you a great holiday!
Looks like you figured it out, Joe.
Since I have no idea what I am looking at (I don't understand the data behind the graphs), it is difficult for me to comment, but I think it all worked as you wanted.