Hi all.
Has anyone already dived into ES|QL?
I'm interested in how to build two queries in one general query.
To then calculate the % ratio based on the results of these queries.
For example
A/(B+A)*100
A - is the first request.
B - second request.
Then this can be calculated through division ES|QL functions and operators | Elasticsearch Guide [8.13] | Elastic and other mathematical operations.
As I understand it, you can’t do this through eval, it seems like you can’t assign an entire request to a variable through eval 