TSVB Table : is There a way to sort columns?

[Hamza_BENNANI]

Hello,

I would like to know if there is a way to sort columns in TSVB Table in Kibana 7.6.2.
Anyway, my need is to compute the top 10 of customers based on their turn over. Also, the table must show in a third column, the evolution of the turn over compared to the last year for each customer.
I was able to do that in TSVB Table but I cannot make a descending sort on the column 'turn over' to get only top 10 customers.

regards,
Hamza

[flash1293 (Joe Reuter)]

You might be running into this bug: https://github.com/elastic/kibana/issues/49626

[Hamza_BENNANI]

I don't think it's the same problem because I'm not even able to sort. Also, when I put the mouse cursor over the column title, I have this message: "This column is not sortable".

[flash1293 (Joe Reuter)]

Ah, it depends on the data in this column whether you can sort by it. What aggregation are you using for TO?

[Hamza_BENNANI]

I'm using 'sum agg' for TO and 'bucket script agg' for EVOL LY %. The 'bucket script agg' is based on sum agg and Serial diff agg by the way.

[flash1293 (Joe Reuter)]

Not all aggregations are possible to sort by (due to the way TSVB builds the Elasticsearch queries behind the scenes).

This is the list of sortable metrics: https://github.com/elastic/kibana/blob/74b9ed6414d8801d4ac3cd9b62715f9f7c742ec8/src/plugins/vis_type_timeseries/common/basic_aggs.js