How create a visualization with the last date of document

[David_Oceans]

Hi,

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

[Marta_Bondyra]

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