Hi Grafana community,
I’m trying to do something in Grafana and I am not even sure if it’s supported. We are using Grafana version 5.2.4 with ElasticSearch 6.2 and what I’ve been asked to do is to create a table panel with the values for specific fields in our ElasticSearch data. The issue I’m trying to overcome is that I only want the values (which are generally text) for the latest version of the event. I have a “documentId” field and essentually I want to return only the latest event containing that documentId when displaying the data for the table. I think I need to do some kind of term aggregation on documentId, but when I use “Raw Document” for the metric so I can create the table, there is no way to aggregate on the documentId that I can see. The only thing I can set there is the size (number of returned events).
Am I missing something on how to do this? Am I providing enough information?