I'm using Elastic and kibana v7.17, and I want to get the percentage from each term in my table. look at this picture below
as you can see there are many counts of records of each term on the right side, how if I want to change that to become a percentage? so the formula will look like this (count of record of each term / count of record of all logs in that timerange)
is that possible to do that using a formula in the lens? if yes, how to do it? since the count function didn't accept any field inside it.
I already tried using a formula like this but it gives me 100% from all terms while I calculate manually it shouldn't get 100%
I already tried TSVB too. Since i only took count of records from each term, i don't know what should i write in the numerator part. After i group the data by field, it also gives me 100% while the actual data doesn't reach 100. I tried to use pie also. It can show the percentage but not suitable if I want to show the top 50. That's why I moved to a table visualization. Do you have any other ideas?
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.