I need an help in order to calculate a percentage value inside a column.
I'm using Kibana 7.16.2 and I have a table with Lens:
1st column: item name ("Alpha", "Beta", "Gamma"....)
from 2nd column to N column a date: sum of purchases ("2020-01-01", "2020-02-01", "2020-03-01"....).
As you can see in my screen:
value A => It's ok!
value B => It's ok!
value C => I would like to see A / B, so 49/144 = 34.03%, not 2.04%
value D => always 100% (not 18.12%)
Now, about the calculation for C I have: unique_count(item_name) / unique_count()
But I think my formula should be something like: unique_count(item_name) / unique_count(sum_previous_column)
With the flights sample dataset, a table with carriers as rows and columns per date interval for count and percentage of count. Showing the definition of the percentage column:
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.