1 Reply Latest reply: Sep 16, 2017 3:36 AM by Stefan Wühl RSS

    How to create a bar chart with multiple calculated dimensions?

    moo Default

      I have a bar chart where I'm using a dimensions like this:

           class(aggr(FirstSortedValue(value, -time), category), 5)

      and the measure is

           count(distinct category)


      This chart looks like I expect

      Screen Shot 2017-09-15 at 3.40.52 PM.png

      Now I want to add a second bar to this chart with a dimension like this:

           class(aggr(FirstSortedValue(value2, -time), category), 5)


      Charting the second dimension on its own also looks like I expect:

      Screen Shot 2017-09-15 at 3.45.08 PM.png

      But using both of those dimensions in one chart looks nothing like I expect:

      Screen Shot 2017-09-15 at 3.43.09 PM.png

      What I would like to see is the two bars from each of the individual charts next to each other.