Hello. Currently we maintain a cluster of 10 Elasticsearch nodes for our customer and we started experimenting with APM. The thing we are missing is a possibility to determine the Apdex score like New Relic describes: https://docs.newrelic.com/docs/apm/new-relic-apm/apdex/apdex-measure-user-satisf…

Kibana can't access the new scripted_field values to calculate or count the total where apdex_score == 1 or something. It sounds like you're trying to use the scripted field in the query bar? The lucene query language doesn't support scripted fields, but you should still be able to create a filte…

Thanks for your reply. I was only using the query bar to test if the field was searchable. Also we use the new query bar only. This on is much more understandable for our customers. We use the latest software version at the moment: 6.4.1 and we are able to find the field with the filters. We can sw…

I see what you're asking now. Unfortunately I don't think that will be possible at the moment. I thought you'd at least be able to do it with timelion, but it turns out timelion only has limited support for scripted fields so far. I've reopened an issue for supporting them in the timelion query lang…

Have you considered adding the adpex_score as a field to each document at index time, e.g. using an ingest pipeline?

Thanks for the pipeline hint. We are now adding the apdex_score field in the pipeline for indexes with transatcion in its documents. The script has changed due to that: "processors" : [ { "set" : { "field" : "transaction.apdex_score", "value" : "{{transaction.duration.us}}", "ignore_…

[image] VincentNijhuis: Apdex = (satisfied request (apdex_score:1)) + (tolerating request (apdex_score:0.5) /2) / total number of requests (count(apdex_score)) Isn't the formula you provided basically a simple average of the apdex_score field, or am I missing something?

The are 3 possible values for this field, 0, 0.5 and 1. For the formula there is no need to use the field with value 0. But we need the total of all fields to determine the Apdex score. the fields with value 0 are part of the total of all fields. for example when looking at 1 week. There might be…

The average for the apdex_score field would be ((7000 * 1) + (6500 * 0.5) + (1500 * 0)) / (7000 + 6500 + 1500) = 0.6833333333

Ow wow i thought the average aggregations would make a different formula. So today i started with a very big facepalm after trying this with test data on my local machine 1500 times value 0 6500 times 0.5 7000 times 1 The average is is indeed working for me. Thank you very much for your patienc…

Discuss the Elastic Stack

Kibana calculate Apdex with value from scripted_field

Elastic Stack Kibana

Topic		Replies	Views
Using script fields in Kibana Elasticsearch	6	725	July 17, 2014
Metric visual for number occurrences of a field and apply arithmetic Kibana	7	2894	June 1, 2016
Painless script field Kibana Вопросы на русском языке	3	744	August 9, 2019
Reference the count of a field name in metrics Metrics elastic-stack-monitoring	16	1052	March 16, 2021
Scripted Fields in kibana not working Kibana	3	671	January 31, 2018

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Kibana calculate Apdex with value from scripted_field

Related topics