Sorting in Kibana Data Table Visualization

[antony_kavin]

Hi All,

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?

Thanks,
Antony

Existing Behaviour:

Trying to Achieve:

[wylie (Wylie Conlon)]

The Kibana data table visualizations (Lens, TSVB and aggregation based) allow column sorting, so you can click the Count column and sort all the rows in descending order. This does not fetch new data, so it just applies a second level of sorting.

For example, in Lens: