Hello, I want to subtract the sum of two metrics in Kibana.

C = A + B

If I have metric C which is the sum of metric A and metric B.

I created metric C with search query "id1:100 && id2:93" and give the total of 14,000,000

I created metric A with search query "id1:200 && id2:93" and give the total of 1,000,000

How do I produce metric B, which is C - A, in Kibana metric visualization (give total 13,000,000) ?

What operator should I use specifically?

1 Like

You can't currently do this, pipeline aggs in Elasticsearch 2.0 will allow you though.

Is there are any another method to do this?

Just to subtract sum of two amount which is generated by agregation, lucene query maybe?

just wondering

1 Like