4 Replies Latest reply: Sep 15, 2016 5:26 PM by Tim Kendrick RSS

    Using TOTAL<> With a Drill-Down Dimension

    Tim Kendrick

      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?

      Bar Chart Snip.PNG