I already have an index which contains data from a MySQL database and I wanted use
Histogram aggregation Kibana so that I can show a
vertical bar chart or a
data table for every single day.
The problem I'm having is that, I don't particularly have, a day or a month or an year field in my db separately. What I have is a
timestamp field in my table, like as follows:
How can i create a scripted field or is there any other way in
Kibana to get only the day, month and the year from the
timestamp so that I can include it in the
Any help could be appreciated.