This content has been marked as final. Show 4 replies
I have a drill down dimension that allows me to drill down into a stacked bar chart three levels. However, I want this bar chart to be a 100% bar chart where all the bars take up 100% of the x-axis, and I understand I need to use the TOTAL<> function. Something like this:
COUNT([Respondent ID]) / COUNT(TOTAL <[Question]> [Respondent ID])
I need to reference the drill-down dimension instead of a static [Question] field. Is this possible so I can turn this chart into a 100% chart?