I have been using Elastic Cloud for more than 6 months now. The version I am using is 7.12.
I am trying to create a data table visualization in Kibana. I have a couple of buckets(Category and Sub-Category) and one metric(Count).While creating both the buckets, I have given 'Order by Metric Count' and 'Order Descending'.
What happens is, the information is first sorted based on 'Category'. And then within that Category, the Sub-Categories are sorted.
What I would like to achieve is, I want the information to be sorted based on the count in the combination of 'Category' and 'Sub-Category'.
I have attached a couple of screenshots below(Existing_Behaviour and 'Trying_to_Achieve') for helping you understand the issue better. Let me know if you need any other information from my end.
Is there any way to achieve what I am trying to do?
Trying to Achieve: