# Kibana line chart issue

**URL:** <https://discuss.elastic.co/t/kibana-line-chart-issue/154602>\
**Category:** Kibana\
**Created:** [October 30, 2018, 9:51am UTC](https://discuss.elastic.co/t/kibana-line-chart-issue/154602 "2018-10-30T09:51:52Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Wayne\_Du](https://avatars.discourse-cdn.com/v4/letter/w/5e9695/32.png) [@Wayne\_Du](https://discuss.elastic.co/u/Wayne_Du)\
**Post date:** [October 30, 2018, 9:51am UTC](https://discuss.elastic.co/t/kibana-line-chart-issue/154602/1 "2018-10-30T09:51:52Z")

</div>

I create a line chart, and the X-Axis as Data Histogram, the Interval is Monthly,  
when there is no data in one month, the value will be ignore in the chart, But I want to it's show 0. Is there any way to set the value is 0, not ignore on this month ?

for example, there are to lines in this chart, there is any data on 2018-04 for the blue one, so it's be ignore on 2018-04, but I want to it show 0 in the char.

![image](https://us1.discourse-cdn.com/elastic/original/3X/4/5/45b06b2152a65f4b0f3708821cdeed77315a20bd.png)

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [October 30, 2018, 4:24pm UTC](https://discuss.elastic.co/t/kibana-line-chart-issue/154602/2 "2018-10-30T16:24:03Z")

</div>

Hey @Wayne_Du, if you add the following to your "JSON Input" displaced under "Advanced" you should get what you're looking for:

 ![14%20AM](https://us1.discourse-cdn.com/elastic/original/3X/7/6/7630193e61b98b1171e1c3c7deb02030deceeee3.png)

---

<div class="post-metadata">

**Author:** ![Wayne\_Du](https://avatars.discourse-cdn.com/v4/letter/w/5e9695/32.png) [@Wayne\_Du](https://discuss.elastic.co/u/Wayne_Du)\
**Post date:** [October 31, 2018, 2:12am UTC](https://discuss.elastic.co/t/kibana-line-chart-issue/154602/3 "2018-10-31T02:12:26Z")

</div>

@Brandon_Kobel Thanks for you response. Which version support this function ? My used the version is 6.3.1  
I add you provide the josn, seen not work.

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

---

<div class="post-metadata">

**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\
**Post date:** [October 31, 2018, 2:53pm UTC](https://discuss.elastic.co/t/kibana-line-chart-issue/154602/4 "2018-10-31T14:53:44Z")

</div>

Hey @Wayne_Du, I'm seeing the same issue that you're seeing when using a Median aggregation, but when using a Count aggregation it works correctly. Would you mind opening an issue [here](https://github.com/elastic/kibana/issues/new?template=Bug_report.md)

---

<div class="post-metadata">

**Author:** ![Wayne\_Du](https://avatars.discourse-cdn.com/v4/letter/w/5e9695/32.png) [@Wayne\_Du](https://discuss.elastic.co/u/Wayne_Du)\
**Post date:** [November 1, 2018, 2:29am UTC](https://discuss.elastic.co/t/kibana-line-chart-issue/154602/5 "2018-11-01T02:29:02Z")

</div>

Thanks @Brandon_Kobel I submit issue [https://github.com/elastic/kibana/issues/24959](https://github.com/elastic/kibana/issues/24959)

---

<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:** [November 29, 2018, 2:29am UTC](https://discuss.elastic.co/t/kibana-line-chart-issue/154602/6 "2018-11-29T02:29:03Z")

</div>

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