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

**URL:** <https://discuss.elastic.co/t/visualize-date-range-pie-using-custom-timestamp-with-format-yyyy-mm-dd-hhss/301456>\
**Category:** Kibana\
**Created:** [April 4, 2022, 7:01am UTC](https://discuss.elastic.co/t/visualize-date-range-pie-using-custom-timestamp-with-format-yyyy-mm-dd-hhss/301456 "2022-04-04T07:01:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashiqab](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ashiqab/32/103144_2.png) [@ashiqab](https://discuss.elastic.co/u/ashiqab)\
**Post date:** [April 4, 2022, 7:01am UTC](https://discuss.elastic.co/t/visualize-date-range-pie-using-custom-timestamp-with-format-yyyy-mm-dd-hhss/301456/1 "2022-04-04T07:01:33Z")

</div>

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:

![image](https://us1.discourse-cdn.com/elastic/original/3X/c/e/ce698d630cbcb1a2ee36bc2dadf2fb1449245660.png)

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

![image](https://us1.discourse-cdn.com/elastic/original/3X/c/3/c3122bdbce422b118115098f5a912237fa2170d1.png)

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

---

<div class="post-metadata">

**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\
**Post date:** [April 4, 2022, 8:46am UTC](https://discuss.elastic.co/t/visualize-date-range-pie-using-custom-timestamp-with-format-yyyy-mm-dd-hhss/301456/2 "2022-04-04T08:46:50Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ashiqab](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ashiqab/32/103144_2.png) [@ashiqab](https://discuss.elastic.co/u/ashiqab)\
**Post date:** [April 4, 2022, 9:10am UTC](https://discuss.elastic.co/t/visualize-date-range-pie-using-custom-timestamp-with-format-yyyy-mm-dd-hhss/301456/3 "2022-04-04T09:10:39Z")

</div>

> [@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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 2, 2022, 9:11am UTC](https://discuss.elastic.co/t/visualize-date-range-pie-using-custom-timestamp-with-format-yyyy-mm-dd-hhss/301456/4 "2022-05-02T09:11:01Z")

</div>

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