9 Replies Latest reply: Jun 11, 2015 1:06 PM by Chad Watson RSS

    Two dimension Chart visualization

    Chad Watson

      I am trying to create a bar chart with two dimensions and one measure. I would like both dimensions to show on my chart. I found in another discussion that to do this I needed to create a second measure and give it a value of 0. That worked, however every single value from the second dimension is being duplicated for every value in the first dimension:

      The ones I've circled in red do not belong in those campuses. Here is the source data:

      The measure is a calculation of how many weekdays there are between the effective date and end date:

      =sum(NetWorkDays(iun_effective_date,iun_ending_date))

       

      What I want to do is to get rid of those names that don't belong with the first level dimension. I've tried everything I can think of from checking "Suppress when Value Is Null" in the dimensions to "Supressing Zero-Values" in the Presentation. Does anyone have any other ideas? I'm not sure if it has to do with how I'm calculating the measure or something else.

       

      Thanks!!!