I have a bar chart that has been changed to AND instead of OR.
When a user selects a bar that bar should display as 100% and all of the other bars need to be a percentage of the bar that was chosen. If they select multiple bars then each of them should be at 100% and all other bars show as a percentage of those chosen.
For example.
User picks Asthma with a member count of 1000. The bar for Asthma should now be 100%. The bar for Cancer will be showing how many of those 1000 members also have Cancer. Let's say 165 members also have Cancer.
So the percentage for Cancer should be 165/1000.
When nothing is select from the chart then the percentage for each condition should be based on the total number of members as the denominator. So if there were a total of 20,000 members then Asthma would be 1000/20000 and so on.
I have tried a few things and nothing works. I am wondering if changing this chart to AND prevents me from doing this?
In the bar chart, create an expression for each value of your dimension (illnesses), the numerator being the members of that dimension value (set analysis) and the denominator the number of members (better use a variabe).
Let the user select the dimension value from a listbox, not from within the graph).
You may need to make some adjustments, but that's pretty close.
