Kibana Heatmap - order by sum of all buckets

Elastic Stack Kibana
1

Hi there,

I have created a Kibana Heatmap of sum("time spent") (y-axis) over a weekly aggregation (x-axis).
In the first weeks of the year "time spent" is quite low and is ramping up later, unfortunately the whole heatmap is ordered by the first bucket.

Is there a way to order the y-axis by the sum of all buckets for each element on the y-axis?

thanks,
Bernie

2

It seems like you are running into the known issue https://github.com/elastic/kibana/issues/11109

In the issue a workaround is described for histograms - I'm not sure whether it's applicable to your case.