Hi Team, Here are my elastic search get results. Can u help me to plot a time series graph with lucene query on grafana? I have the data source configured. {“took”:3,“timed_out”:false,"_shards":{“total”:5,“successful”:5,“failed”:0},“hits”:{“total”:4,“max_score”:0.2876821,“hits”:[{"_index":“region_…

Yes the epoch time did the trick… but in cost of having two more fields :frowning: for grafana it should be allowed as it is a normal operation for elastic.

This was a bit tricky but this seems to work using the script field. _value in this case is the @number field and I am adding the @value field to it. [image]

Thanks @daniellee … U saved my day !

Hi Team, I think I have the same issue here! in kibana, I can create script field, then I can use it in aggs… How to do it in grafana (also how to perform mathematical operations on two fields and create new field?): in Kibana field is: "script_fields" : { "Delay": { "script": { …

@michaelaeino not sure if that will work? Are you getting an error?

@daniellee I’m not sure how or where to add this… is it defined as templated? or directly in the graph query! & what the correct syntax? I’m really new with Grafana :blush:

I was thinking you would use the script field like in this answer: Basic Elastic Search Query

I can write a new name instead of “@number” , & the script i added only the equation doc['End_Time'].value - doc['timestamp'].value but nothing happened! is that possible here to type my own field name so it is get created ? also to calculate it’s value from other fields ?

This is why aliases exist I believe. Here is how i do it … [image] Here is my script - _value-doc[‘h_1.memory_used_mb’].value as you see i am having my own field on graph as alias - free_memory which is a subtracted value of document field h_1.memory_mb and h_1.memory_used_mb Hope this helps

Hi @coolshiva123 , yes i think this will work… but my problem is that my field is timestamp not number… i can’t select any of them here… anybwork around here ?

Basic Elastic Search Query

Grafana Elasticsearch

michaelaeino July 6, 2017, 8:36pm 9

can i add variable & inject this script inside it ?

I have tried to do that by several syntaxes… with no luck

I got this error:
Template variables could not be initialized: a.metricFindQuery(...) is undefined

Topic		Replies	Views
Grafana to use substraction of two fields in Elasticsearch data source Elasticsearch	3	4755	November 19, 2020
DataSource=EleasticSearch 5.x -> Scripted Field in Grafana	1	5019	November 20, 2017
Get difference between two datetime fields Elasticsearch	0	1906	March 26, 2021
Perform time arithmetic operation on two time fields in Grafana+ Elastic Search Grafana	0	499	May 10, 2019
Apply Elasticsearch script in grafana to visualize the results Elasticsearch	0	793	October 8, 2019

Basic Elastic Search Query

Related topics