New metric Percent based on a total

Elastic Stack Kibana
1

Hi there,
Thank you in advance for your time,
I was wondering if doing this table below is still impossible using Kibana :

values | count | %
aaaaa | 10 | 50
bbbbb | 5 | 25
cccccc | 5 | 25
total | 20 | 100

I have 'aaaaa', 'bbbbb' and 'cccccc' in database, I'm using the metric count of Kibana and the total is calculated by Kibana too. But then I'd like to know the percentage of each values based on this total ...
I read on different forums quite old that it was not possible so far
There is maybe another way to do it that I haven't though about
Thanks !
Guillaume

2

As part of a table like that, it's still not possible. The problem is that getting those values requires a bit of processing on the aggregated data; you need to get the sum of all the aggregated count values and use that to derive the percentage value, and Kibana does not have a way to do that.

You can manually get that value, kind of, assuming you know the "upper bound" of your data, by using the Gauge of Goal visualizations, as it will present the value as a percentage of the upper bound you defined. However, if your upper bound isn't a fixed value, that won't work.

It's something the team is working on currently and this should be possible in the future. You can get this today in Canvas, which is still in beta, but it would require that you learn how the expression language in that tool works. And since it's not ready for production use, that may not be an option. If you're interested in learning about it though, see here: https://www.elastic.co/guide/en/kibana/current/canvas.html

3

Hi @Joe_Fleming and thanks for your help,
I will wait till the version then and try to find another way ...
I think this possibility can suit a lot of people
All the best
Cheers

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.