4 Replies Latest reply: May 6, 2009 2:25 AM by John Witherspoon RSS

    How to display multiple boolean dimensions along the X-axis?

      Hi folks. I have a somewhat strange graph I'm trying to build and I can't figure it out.

      So I have 5 boolean (Yes/No) fields in my table, let's call them Flag1-5. I have another dimension called Category.

      I want to create a stacked bar graph that shows how many records exist that have each flag set segmented by Category.

      So I want to see the 5 flag fields along the X axis, so 5 bars, and each bar segmented by Category, with the count as the expression.

      Since you can only have 2 dimensions in a stacked bar graph, I'm not sure how to do this. Can anyone give me some advice and examples? Thank you!