How create a visualization with the last date of document


I would like create a dashboard / visualization with the timestamp of even better with the days from the first document in my indexes, like that

Option A)
First document found
13-03-2022 10:00

Option B)
Retention Days for that index
7 days

I achieve the query to get the first document, like that

POST my_index-*/_search
   "size": 1,
   "sort": { "@timestamp": "asc"},
   "query": {
      "match_all": {}

But I don't know how create this kind of visualization.

Could you help me?

Thank you very much

what kind of visualization you have in mind? An example for a datatable (same config would work for any aggregation)

Screenshot 2022-03-21 at 14.00.17

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.