I'm trying to make a heatmap view of data that's categorized on two different dimensions, each of which has a natural order. It looks something like this:
As you can see the Y "class" axis is not in the ascending order by term as I wanted.
I can give the Y axis priority so that it does appear in the correct order like this:
But now the investigation number is not in increasing order.
I think I understand what's going on -- it sorts the sub-aggregations within the scope of each primary item separately -- but is there any way to simply fix the order of both axes to be (globally) increasing by term?