Create Gauge graph


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


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

@alessandroperetti What is PPL?

PPL stands for Piped Processing Language PPL