Date histogram Not working

Elastic Stack Kibana
1

To migrate my all MySQL data to elasticsearch I used the bulk indexing. After I migrate all my older data. I started to sync my current data flow to the elasticsearch.

when I use kibana to discover the new data, it shows "No result Found". But when I try to discover the older data I can get the results.

The problem got deeper when I try to sort my data by date_field it is working perfectly. But when I try to use data_histogram to aggregate the result, newly indexed data is not showing.

Please, someone, suggest me what I did wrong. Thanks, Advance.

2

The index pattern that you use to view your data in Kibana should have a time field attributed with it (for example, @timestamp), since you are working with time-based data. Check that the time field you have chosen for the index pattern has the right values in your source data.

But when I try to discover the older data I can get the results.

This tells me that the time field in your older data is correct.