Visualize date range pie using custom timestamp with format YYYY-MM-DD-HH:MM:SS

[ashiqab]

Dear all,

I am trying to visualize a pie chart using one of my custom timestamp columns available in my custom log which has the format YYYY-MM-DD-HH:MM:SS (example 2020-02-18-00:13:17).

However "create visualizations" does not consider my custom timestamp.keyword column as a valid timestamp using which I can create a date range graph:

As you can see, it does not take any other option for date range split although we have timestamp.keyword in the data:

Could you please suggest any workaround for adding YYYY-MM-DD-HH:MM:SS format timestamp for date range visualizations?

Thanks and regards,
Ashiq Aboo Backer

[Stratoula_Kalafateli]

Data range works with date or date_range field types and not with keyword fields. This is the reason you dont see it as an option when you are selecting this aggregation.
You have to change the mapping of this field to date or create a runtime field to create a new date field from the keyword field.

[ashiqab]

@Stratoula_Kalafateli

Data range works with date or date_range field types and not with keyword fields

Thank you for the prompt response Stratoula!

I shall look into the options for mapping this field to proper date format.

Thanks and regards,
Ashiq