I would like to query two separate indices.
I would like to do the following:
Query 1: Query metricbeat which returns a figure say for arguments sake 2,500,000. I would like to divide this by 1,000,000 which gives me a values of 2.5
Query 2: Query custom index which returns a value of 8000.
Calculate: Divide result of query 2 (8000) by the result of query 1 + calculation (2.5)
Graph: Graph the resulting value
Is this possible in Kibana? In any of the options I have looked at Lens and TSVB, this doesn't seem possible. In Lens, I can't use a Bucket Script on the queries. In TSVB I can't query more than a single index.