Kibana: aggregation of timestamp field with date

Hi Team,
I have a timestamp field which is coming from my log data source, the format is like:
"batchDate": "2019-05-30 09:11:08"

But in visualization, I wanted to make the chart on each day basis from the same field as I do not have any other filed in my log data.

Currently, I have tried the same, on index pattern I changed the format from above to "DD MMM YY", in discovery I can see the expected format, but when I use the same batchDate in Kibana for x-axis I have multiple entries in x-axis for the same date.

I am thinking still, aggregation is happening at old format instead of just date one.

Please help on this, any kind of guidelines is welcome.

If I understand correctly, you should not need to change the format of the date in the index pattern. You can use the Date Histogram aggregation in the visualization and specify the interval to use ("Daily" in your case).

1 Like

Awesome, I was using it totally wrong.
Thanks for the help.

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.