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