I have two date fields in index, record_time and @timestamp, the values of these two fields should be the same, and their format is different. record_time is generated by php code, and @timestamp is generated by logstash automatically.
This is the screen catch of Kibana indice setting, you can see they are both recognised as date field
This is the screen catch of the two field presentation in Kibana discover page
This is the screen catch of the raw data format of the two field presentation in Kibana discover page
The following is screen catch when I use record_time field range aggregation on Kibana to aggregate count for each hour
The following is screen catch when I use @timestamp field range aggregation on Kibana to aggregate count for each hour
You can see when I use @timestamp , I can get aggregated result, but when I use record_time the aggregated result is not 0 ( kibana does not recognise record_time field properly)
Not only in date range visualisation, but also other visualisation like date histogram, if I use record_time the result is empty.
How can I make Kibana use this field correctly?