I have 2 x Elasticsearch indexes and I've made one Kibana index using the * wildcard index name.
I'd like to present 2 top hit (latest) values in a table; one value from each Elasticsearch index - so these are 2 different documents that I want to query.
Quite simply, Kibana fetches the latest document and then presents one Top Hit value (which exists in that document), and a "-" character in place of the other value.
By setting a filter of _index: a or b, I can toggle which value is shown.
My question, can I use the "JSON input" or other solution to show the Top Hit (latest) value for each metric, where each metric is filtered to it's respective Elastic index? Can I get an example of how to do this, please?
Thanks in advance!