# Absence of some X.AXIS values in Bar chart or line chart

**URL:** https://discuss.elastic.co/t/absence-of-some-x-axis-values-in-bar-chart-or-line-chart/49624
**Category:** Kibana
**Created:** [May 10, 2016, 8:54am UTC](https://discuss.elastic.co/t/absence-of-some-x-axis-values-in-bar-chart-or-line-chart/49624 "2016-05-10T08:54:41Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![saba\_soltani](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@saba\_soltani](https://discuss.elastic.co/u/saba_soltani)
#### Post date: [May 10, 2016, 8:54am UTC](https://discuss.elastic.co/t/absence-of-some-x-axis-values-in-bar-chart-or-line-chart/49624/1 "2016-05-10T08:54:41Z")

</div>

Hi every one

I want to make a bar chart or line chart based on a string value or either number in X.AXIS. The point is for some of these value in x axis, there is no value in the data set so I won't have those values in x.axis.  
For example, I want to show the "Count" of events in each day of week in a bar chart or line chart but no event has been happened on Monday. Then I will have 6 values (instead of 7) in x.Axis . Is there any way to have Monday with value 0? The same issue exists for Line chart.

Regards

---

<div class="post-metadata">

### Author: ![shaunak](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shaunak/32/6643_2.png) [@shaunak](https://discuss.elastic.co/u/shaunak)
#### Post date: [May 10, 2016, 10:43am UTC](https://discuss.elastic.co/t/absence-of-some-x-axis-values-in-bar-chart-or-line-chart/49624/2 "2016-05-10T10:43:23Z")

</div>

What type of aggregation (buckets) are you using for the X-axis?

 ![](https://us1.discourse-cdn.com/elastic/original/2X/7/7f3d3b95eba623f2157f12dd2345315d342554c6.png)

---

<div class="post-metadata">

### Author: ![saba\_soltani](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@saba\_soltani](https://discuss.elastic.co/u/saba_soltani)
#### Post date: [May 10, 2016, 10:49am UTC](https://discuss.elastic.co/t/absence-of-some-x-axis-values-in-bar-chart-or-line-chart/49624/3 "2016-05-10T10:49:58Z")

</div>

I am using Filters and Terms aggregation for Bar chart and Terms aggregation for Line chart.

---

<div class="post-metadata">

### Author: ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)
#### Post date: [May 16, 2016, 7:29pm UTC](https://discuss.elastic.co/t/absence-of-some-x-axis-values-in-bar-chart-or-line-chart/49624/4 "2016-05-16T19:29:48Z")

</div>

I think you must be starting with a Date Histogram first if you want to see dates along the X-Axis?  
The chart in this case will show the dates for the time range you have specified. In my case March 16th - April 7th even though there's no data for many of these dates. But the table doesn't show "0" for the other dates. I don't think there's any way to make it do that.

 ![](https://us1.discourse-cdn.com/elastic/original/2X/7/7bcda9f33430aed83be0700328eced37124514be.png)

---

<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: [July 6, 2017, 1:53pm UTC](https://discuss.elastic.co/t/absence-of-some-x-axis-values-in-bar-chart-or-line-chart/49624/5 "2017-07-06T13:53:14Z")

</div>