I have categorical variables for medical conditions and related categorial sub-variables. For example, one categorical medical condition is Cancer, and the sub-vars are Lymphoma, Lung, and Other. All of these vars have Yes/No/Unknown responses in the data. I want to display the yes/no/unknown counts for the sub-variables in the datatips so when you mouse over the columns, you'll see the number of people who have the specific sub-condition. I have a bar graph for Cancer (yes/no/unknown), then I calculated the Yes responses for the sub-variables to be able to display them as data tips when mousing over the Yes column for Cancer like so: IF ( 'lymphoma'n In ('Yes') ) RETURN 1 ELSE 0 However, this (obviously) doesn't calculate the No/Unknown values and when mousing over those columns, the values are 0 for Lymphoma (frequency). How can I calculate the sub-variables to display the correct counts for the No/Unknown values? TIA!
... View more