Kibana bar chart empty if ranking is used

Elastic Stack Kibana
1

Hi,

we imported several dashboards for uberAgent and try to bring them to the latest and greatest Kibana version. While still in test mode, we create some new visualizations and I have a problem.

We have a list of processes with their average CPU and RAM usage over a period of time. In table mode, I can see all processes and their values and sort them correctly. I try to convert these information into two bar charts. ProcessName/avg CPU and ProcessName/avg RAM.

This is working fine, until I try to sort the bars. I try to sort by avg(CPU) or avg(RAM) and all values are empty. It doesn't matter if I sort asc or desc.

working:

grafik
grafik1377×707 90.6 KB

Does someone have an idea, how to solve this problem? I'm fairly new to Kibana. Normally I use Grafana so basic concepts of dashboards and visualizations are present :slight_smile:

Thanks

René

2

grafik
grafik422×503 19.7 KB

3

not working desc:

grafik
grafik1492×688 90.4 KB

4

Hi @Rene_S

if you click on the Inspect button on the top bar do you see any data in the table?

Also mind that this is a Ranking option (so how things are fetched from ES), so not a chart sorting feature (how things are sorted on the chart).
If you are looking on how to sort the items on the chart, you can track this feature enhancement: [Lens] Allow client-side sorting of dimensions and legends at datasource level for all chart types · Issue #86184 · elastic/kibana · GitHub

As an alternative you could create a ES|QL chart and impose a sorting in the query, then the chart will just follow that order.