Kibana visualization search only the latest value

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

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

Hi,

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

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.

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

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