# Create line chart with date

**URL:** <https://discuss.elastic.co/t/create-line-chart-with-date/228269>\
**Category:** Kibana\
**Created:** [April 16, 2020, 7:59am UTC](https://discuss.elastic.co/t/create-line-chart-with-date/228269 "2020-04-16T07:59:44Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![DG13](https://avatars.discourse-cdn.com/v4/letter/d/a5b964/32.png) [@DG13](https://discuss.elastic.co/u/DG13)\
**Post date:** [April 16, 2020, 7:59am UTC](https://discuss.elastic.co/t/create-line-chart-with-date/228269/1 "2020-04-16T07:59:44Z")

</div>

Hi ,  
I have timestamp field coming in data however would like to have one of the chart as line chart with date instead of date .  
I tried truncating the timestamp to date but the chart is showing a straight line instead of showing the correct count .  
FYI : Would like to create chart with Date and count data .

Thanks,  
Divya

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [April 16, 2020, 12:59pm UTC](https://discuss.elastic.co/t/create-line-chart-with-date/228269/2 "2020-04-16T12:59:15Z")

</div>

You want only the date and not the time?

---

<div class="post-metadata">

**Author:** ![DG13](https://avatars.discourse-cdn.com/v4/letter/d/a5b964/32.png) [@DG13](https://discuss.elastic.co/u/DG13)\
**Post date:** [April 24, 2020, 3:40am UTC](https://discuss.elastic.co/t/create-line-chart-with-date/228269/3 "2020-04-24T03:40:15Z")

</div>

yes only date

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [April 30, 2020, 5:04pm UTC](https://discuss.elastic.co/t/create-line-chart-with-date/228269/4 "2020-04-30T17:04:11Z")

</div>

You can use a scripted field to truncate the timestamp to only show the date. Then you can only have that displayed.

---

<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 28, 2020, 5:04pm UTC](https://discuss.elastic.co/t/create-line-chart-with-date/228269/5 "2020-05-28T17:04:12Z")

</div>

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