How to create a bar chart with multiple calculated dimensions?

[#1]

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

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:

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

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

[swuehl]

Instead of using two fields value and value2, use a CROSSTABLE LOAD approach to create a single value_combined field and value_type field, creating two records for each input record.

The Crosstable Load

Now use a single calculated dimension using the new  fields

  class(aggr(FirstSortedValue(value_combined, -time), category, value_type), 5)

and two expressions:

=Count({<value_type = {'value'}>}DISTINCT category)

=Count({<value_type = {'value2'}>}DISTINCT category)