Ordering for both axes of heatmap

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?

1 Like

Hi Boris,

sorry for the late reply.

You explained exactly correct what Elasticsearch is doing here. Also within each of the high-level buckets different sub-buckets could exist, so it would be hard for ES to do a global ordering.

The only thing we could do, is building an option, that Kibana does the sorting on both axes for you. If you think that's an useful feature, please feel free to open an issue for this on GitHub.


Thank you for the response!
I've filed an issue here: https://github.com/elastic/kibana/issues/14536


This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.