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?
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.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.
