Create Gauge graph

Grafana Elasticsearch
#1

Hi,

I queried my ES index through PPL and I got the following result to create a Gauge:

image

I should extract a specific object from the array of 9 objects that I have using its value to fill gauge graph. Is it possible with Grafana transform or there are other smarter way to achieve it?

Thanks in advance

#2

@alessandroperetti What is PPL?

#3

PPL stands for Piped Processing Language PPL