Kibana: aggregation of timestamp field with date

igour · June 1, 2019, 2:33pm

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.

nickpeihl · June 3, 2019, 4:17pm

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).

igour · June 6, 2019, 10:23am

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

system · July 4, 2019, 10:23am

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

Topic		Replies	Views
Custom date format on visualizations Kibana	3	5438	April 10, 2020
Date Histogram - Date Format Change Kibana	3	651	March 9, 2022
Date Histogram Problem Kibana	3	3190	February 16, 2017
Kibana Date Range Aggregation format Kibana	2	3645	October 11, 2017
Creating a new date field by splitting an existing timestamp in Kibana 5.0.0 Kibana	2	1575	July 6, 2017

Kibana: aggregation of timestamp field with date

Related Topics