How can I subtract sum of two metrics visualization

Elastic Stack Kibana
1

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
2

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

3

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