You could achieve this by using the Advanced Json input for Kibana charts. Here, I could link you to a more detailed discussion on advanced Json input. It will query Elasticsearch for the data, and then the formula is performed in the script based on the values from elasticsearch. Feel free to come back with more questions if you have.
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.