I was trying to create a scripted field of my data by concatenating 2 fields so that I could group results on my dashboard in the x-axis by this field. I was able to do this in kibana by creating a scripted field as such: return doc['srcAS'].value + '-' + doc['dstAS'].value I was then able to crea…

This is the query that I see Grafana sends to ES: "{"search_type":"query_then_fetch","ignore_unavailable":true,"index":["sflow-2017.10.23","sflow-2017.10.24"]} {"size":0,"query":{"bool":{"filter":[{"range":{"@timestamp":{"gte":"1508731200000","lte":"1508817599999","format":"epoch_millis"}}},{"query…

Like this? [image] Basic Elastic Search Query Elasticsearch 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]

It is somewhat like that, but instead of using that script field as a metric, I want to use it as the field for the “Group By” or X-axis bucket. Currently, in Grafana, I have this: [37 AM] Where each of those numbers is a single field. I want to achieve something like this, where the metric is p…

I notice I am able to do multiple “Group By” sections, and it gives me something closer to what I want in the legend. But it shows 100 total bars, when I want only 10.

I don’t know then - doesn’t look like it is currently possible.

This feature request was the closest I could find to what you need: [image] Issue: advanced elasticsearch query option for building custom aggregations opened by yehosef on 2015-11-08 closed by yehosef on This is copied from elastic/kibana#5282 - But if it could be done …

Scripted fields to concatenate field names

Grafana Elasticsearch

daniellee October 24, 2017, 12:34pm 3

Like this?

Topic		Replies	Views
DataSource=EleasticSearch 5.x -> Scripted Field in Grafana	1	5075	November 20, 2017
Apply Elasticsearch script in grafana to visualize the results Elasticsearch	0	804	October 8, 2019
Basic Elastic Search Query Elasticsearch templating	25	71694	August 28, 2021
How to use Elasticsearch's scripted metric aggregations with Grafana Grafana	1	2290	May 12, 2017
How to use Elasticsearch Scripted Fileds in Grafana? Elasticsearch elasticsearch	0	839	July 30, 2020

Scripted fields to concatenate field names

Related topics