I would like to have calculation like you see in the image. [grafik] How to solve that? I was trying: { "script" : { "lang": "painless", "inline": "_value * params.manualSeconds / params.correction / params.factorCount", "params" : { "manualSeconds" : 600, "correc…

What about using a bucket script? Since it's a pipeline aggregation it is only operating on aggregated data so you shouldn't see a performance hit. [image]

@kwoxer thanks for your question. We'd like to route this to the right team. Can you tell us more about what part of Kibana (and what version) you are using for this?

Sure, here the info: Kibana v 7.8.1 And part of Kibana? Well I just want to create some calculations. So in this example I have a timespan and want to know how much time my robot saved compared to when a human would have done it. So as you can see the robot ran 3 times. And the average completio…

Ohh and I also tried to use the Metric explorer but the Chart is always empty. And I also didn't find out any tutorial that helped me there. Not sure what I do incorrect there. I tried out any different Average and graph per and so on: [grafik]

@kwoxer Is STATISTIC-TRANSACTION-COMPLETE-RATEa scripted field you created in an index pattern? If so, the Metrics Explorer doesn't have support for those fields... yet. We are working on integrating with Kibana index patterns and ultimately the new runtime fields implementation which will be perfec…

Nop, its a normal field. Is there no way in referencing like a described in my example above?

Not for Metrics Explorer, you can do that using TSVB (under Visualizations). We are working on supporting runtime fields via Kibana index patterns. Unfortunately, I don't have a timeline for when that will be released.

I just solved my issue kind of with the Sum of a Scripted field. But as Scripted fields are slower and very static I would more prefer a better way if possible. Also I also need this 1680 seconds value as visualization. Sure I could now hide the other values simply but it will still remain as a tabl…

Cool that worked. [image] Maybe the last question. As you can see on SCANUC process, when there is no field in the TimeSpan. Is there any way to just show a 0 maybe instead of no data? But this is really just cosmetic, overall it works have many thanks.

Reference the count of a field name in metrics

Elastic Observability Metrics

kwoxer (Curtis Mosters) March 9, 2021, 7:47am 8

Good to know, yes that is looking kind of what I need. But now how to reference the count? Really hard to understand. Or is it impossible with the TSVB?

Topic		Replies	Views
Metric visual for number occurrences of a field and apply arithmetic Kibana	7	2894	June 1, 2016
Add math to metrics in kibana Kibana	2	2249	May 19, 2018
Kibana visualize metric I'm not able to subtract with _value Kibana	3	833	April 6, 2021
Using script fields in Kibana Elasticsearch	6	722	July 17, 2014
Arithmetic operations on count result Kibana	5	12175	June 18, 2016

Reference the count of a field name in metrics

Related topics