How to apply new time format of range in kibana's request query when visualizing data

Elastic Stack Kibana
1

Hi,
I have a question about changing time format in range query when visualizing data.

I have a date field 'time local' and its format is "dd/MMM/YYYY:HH:mm:ss Z"
ex.
"time_local": "15/Nov/2019:16:49:53 +0900",

The problem is that
kibana always use "strict_date_optional_time" time format in range query to search data and
with this time format my data is not appeared in visualization.

image

image
image.png1730×580 28.5 KB

My es query with correct date format in range , elasticsearch gave a right answer.

image
image.png851×877 35.2 KB

Is it possible to change time format in range query in Kibana visualization request?

Thank you :slight_smile:

2

I think that you don't need to change the format in range query.

If you change the mapping setting in time_local from "dd/MMM/YYYY:HH:mm:ss Z" to "dd/MMM/yyyy:HH:mm:ss Z", you can find your expected result.

Here is my configurations and test results.

image
image.png1903×941 75.4 KB

I hope this will help.

3

OMG, it works!!
I really appreciate you!! :laughing::laughing: