On a "meta" board, I want to visualize the "freshness" of the indexed data, meaning the age of the newest indexed document.
Currently I've done it with a scripted field per index:
(System.currentTimeMillis() - doc['date'].value.getMillis()) / 1000 / 60 / 60
and then visualize the minimum of that field.
But that feels very bungling, as it first needs to calculate all the diffs and then get the minimum. It would feel more natural to get the max of the date field and then calculate and display the hours till now.
But how do I do this? Any help appreciated.