Kibana visualization search only the latest value

[Ashutosh_Pachisia]

Is there any way in kibana to search data only of the latest timestamp

I have a dataset that repeats every (10min-15 min ) not fixed interval with a different set of values
I want the historic data as well as the latest data in the visualization .
Please help
Eg :
@timestamp | locations | status
@now. ABC. 1
@now. DEF. 2
@now-5min. ABC. 4
@now-5min. DEF. 3

Final output
@timestamp | locations | status
@now. ABC. 1
@now. DEF. 2

[kiyapedia]

Hello @Ashutosh_Pachisia —

If I understand your question correctly, you want to create a visualization that shows you both your latest data and historic data in one view? If that's the case, I suggest you create two separate visualizations: one for your historic data and one for your latest data. Then, you can add both visualizations to a dashboard two view at the same time.

Let me know if this helps.

Thanks

[Ashutosh_Pachisia]

Hi,

No i want a metric to see only the latest data removing the duplicates

[kiyapedia]

Ah, in that case you will want to select unique_count under metric aggregations and select the field of the value you’re looking for.

[Ashutosh_Pachisia]

Hi ,
Yes Selecting Unique_count is ok for a particular field but what about the other data attached to the unique field which needs to be latest of all the timestamps