Search code examples
elasticsearchkibanakibana-5kibana-6

Add math to metrics in kibana


I have this count metric:

enter image description here

Is it possible this number (457) multiply on some coefficient ?

For example 457 * (10 / 29) to get: 157,58


Solution

  • It's possible, you need to use Calculation aggregation. Create a new Visual Buidler and select Metric at the top, choose count as the first aggregation and then click on plus button on the right in order to add another aggregation. As the second aggregation choose Calculation. Name your variable and from expandable list pick Count next in the Painless Script field type in your desired formula params.count * 10 / 29. That's how it should look like:

    enter image description here