Hello, I want to write a script in Timelion to get a ratio. The idea is : count(field_name) is not null divided by count(field_name) The index name: call The field name I want to count : drop_rate The value of drop_rate are 1,2,5,NULL. My script: .es(index='call',timefield=ts, q='exists:drop_…

@tylersmalley Thanks, I figure it out, here is my script. (.es(index='call',timefield=ts, q='exists:drop_rate).divide(.es(index='call',timefield=ts))).multiply(100).yaxis(label="Drop Percentage").lines(width=3, fill=3, steps=T).color(green)

Discuss the Elastic Stack

How to use timelion to get a ratio

Elastic Stack Kibana

system (system) Closed November 24, 2017, 3:10pm 5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Graph a ratio between two counts Kibana	8	10269	November 4, 2022
Subtract two fields in a Timelion Query Kibana	2	2970	August 8, 2017
Timelion drawing Kibana timelion	4	377	December 18, 2019
Timelion-style queries Elasticsearch	7	2928	July 5, 2017
Calculating ratio per date Kibana	2	913	July 6, 2017

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.

How to use timelion to get a ratio

Related topics