I am displaying my data in grafana using elasticseach as a datasource and using a plugin there called metaqueries to help do a calculation on elasticsearch's field like:
D: (A+B) / C
I am able to display the data correctly on a graph, but unfortunately this plugin does not support setting an alert so I am looking for an alternative way.
What I am thinking of is to calculate the fields in elasticsearch from multiple different queries and add that calculated field into a new index, I thought of using a job that runs a program which queries from elasticsearch, calculate the field and add it back into a new index which I will then use in grafana to display in a graph.
Is there any way I can do this calculation in kibana instead?