I am working on a PoC to visualise 5 years worth of data records.
I have used the PHP client to import 5 years worth of data into my Indicies.
I have a date field in each document called 'DateObtained' which is a date format 'yyyy-MM-dd'.
I want to visualise this data using Kibana, this includes using the Date picker on the top right to filter the data.
This is currently not working and after much searching I can't see any documentation around this concept, although I must assume that this is a common need.
How do I get the Date picker to filter my data?
Do I need to add a new date field with a different date format?
Is there a way to point the Date picker to a specific field in my Indices?
Any help would be appreciated.