# Kibana fails to show future date on line chart

**URL:** <https://discuss.elastic.co/t/kibana-fails-to-show-future-date-on-line-chart/68806>\
**Category:** Kibana\
**Created:** [December 13, 2016, 3:09am UTC](https://discuss.elastic.co/t/kibana-fails-to-show-future-date-on-line-chart/68806 "2016-12-13T03:09:27Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![YuWatanabe](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yuwatanabe/32/13259_2.png) [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)\
**Post date:** [December 13, 2016, 3:09am UTC](https://discuss.elastic.co/t/kibana-fails-to-show-future-date-on-line-chart/68806/1 "2016-12-13T03:09:27Z")

</div>

I have kibana (v 5.1.1) configured to display future dates on line chart.

However, query seems to succeed but I get below error in the browser.

```
commons.bundle.js:38 TypeError: 
Cannot read property 'orderBucketsBySum' of undefined

    at Data.value (http://somehost:5601/bundles/kibana.bundle.js?v=14566:44:31056)
    at http://somehost:5601/bundles/kibana.bundle.js?v=14566:44:31664
    at Array.forEach (native)
    at Data.value (http://somehost:5601/bundles/kibana.bundle.js?v=14566:44:31482)
    at new Data (http://somehost:5601/bundles/kibana.bundle.js?v=14566:44:24195)
    at getData (http://somehost:5601/bundles/kibana.bundle.js?v=14566:46:16670)
    at Object.line (http://somehost:5601/bundles/kibana.bundle.js?v=14566:46:16818)
    at Vis.value (http://somehost:5601/bundles/kibana.bundle.js?v=14566:54:25848)
    at Function.uiState._uiStateChangeHandler (http://somehost:5601/bundles/kibana.bundle.js?v=14566:54:25729)
    at http://somehost:5601/bundles/commons.bundle.js?v=14566:55:663

```

 ![](https://us1.discourse-cdn.com/elastic/original/2X/8/88b53a9adac699a2bebb39313f609ba235218448.PNG)

 ![](https://us1.discourse-cdn.com/elastic/original/2X/8/8486973f9af4f2c3717ee7689b1280bdfb4b89e0.PNG)

Am I missing any configuration ? I thought this was working in v5.0.1

---

<div class="post-metadata">

**Author:** ![YuWatanabe](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yuwatanabe/32/13259_2.png) [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)\
**Post date:** [December 13, 2016, 3:10am UTC](https://discuss.elastic.co/t/kibana-fails-to-show-future-date-on-line-chart/68806/2 "2016-12-13T03:10:10Z")

</div>

Below is the full result of query and response.

**Query:**

```
{
  "query": {
    "bool": {
      "must": [
        {
          "query_string": {
            "query": "*",
            "analyze_wildcard": true
          }
        },
        {
          "query_string": {
            "analyze_wildcard": true,
            "query": "*"
          }
        },
        {
          "range": {
            "@timestamp": {
              "gte": 1479005148266,
              "lte": 1481597148266,
              "format": "epoch_millis"
            }
          }
        }
      ],
      "must_not": []
    }
  },
  "size": 0,
  "_source": {
    "excludes": []
  },
  "aggs": {
    "2": {
      "date_histogram": {
        "field": "ReportWeek",
        "interval": "1w",
        "time_zone": "Asia/Tokyo",
        "min_doc_count": 1
      },
      "aggs": {
        "1": {
          "avg": {
            "field": "AC"
          }
        },
        "3": {
          "avg": {
            "field": "EV"
          }
        },
        "4": {
          "avg": {
            "field": "PV"
          }
        }
      }
    }
  }
}
```

---

<div class="post-metadata">

**Author:** ![YuWatanabe](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yuwatanabe/32/13259_2.png) [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)\
**Post date:** [December 13, 2016, 3:11am UTC](https://discuss.elastic.co/t/kibana-fails-to-show-future-date-on-line-chart/68806/3 "2016-12-13T03:11:16Z")

</div>

**Response:**

```
{
  "took": 108,
  "timed_out": false,
  "_shards": {
    "total": 5,
    "successful": 5,
    "failed": 0
  },
  "hits": {
    "total": 108,
    "max_score": 0,
    "hits": []
  },
  "aggregations": {
    "2": {
      "buckets": [
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 16250
          },
          "key_as_string": "2017/01/30 00:00:00",
          "key": 1485702000000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 41250
          },
          "key_as_string": "2017/02/06 00:00:00",
          "key": 1486306800000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 70000
          },
          "key_as_string": "2017/02/13 00:00:00",
          "key": 1486911600000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 98750
          },
          "key_as_string": "2017/02/20 00:00:00",
          "key": 1487516400000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 126250
          },
          "key_as_string": "2017/02/27 00:00:00",
          "key": 1488121200000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 167500
          },
          "key_as_string": "2017/03/06 00:00:00",
          "key": 1488726000000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 221250
          },
          "key_as_string": "2017/03/13 00:00:00",
          "key": 1489330800000,
          "doc_count": 6
        },
```

---

<div class="post-metadata">

**Author:** ![YuWatanabe](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yuwatanabe/32/13259_2.png) [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)\
**Post date:** [December 13, 2016, 3:12am UTC](https://discuss.elastic.co/t/kibana-fails-to-show-future-date-on-line-chart/68806/4 "2016-12-13T03:12:55Z")

</div>

```
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 275000
          },
          "key_as_string": "2017/03/20 00:00:00",
          "key": 1489935600000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 331250
          },
          "key_as_string": "2017/03/27 00:00:00",
          "key": 1490540400000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 337500
          },
          "key_as_string": "2017/04/03 00:00:00",
          "key": 1491145200000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 341250
          },
          "key_as_string": "2017/04/10 00:00:00",
          "key": 1491750000000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 385000
          },
          "key_as_string": "2017/04/17 00:00:00",
          "key": 1492354800000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 408750
          },
          "key_as_string": "2017/04/24 00:00:00",
          "key": 1492959600000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 462500
          },
          "key_as_string": "2017/05/01 00:00:00",
          "key": 1493564400000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 513750
          },
          "key_as_string": "2017/05/08 00:00:00",
          "key": 1494169200000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 522500
          },
          "key_as_string": "2017/05/15 00:00:00",
          "key": 1494774000000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 526250
          },
          "key_as_string": "2017/05/22 00:00:00",
          "key": 1495378800000,
          "doc_count": 6
        },
        {
          "1": {
            "value": 0
          },
          "3": {
            "value": 0
          },
          "4": {
            "value": 526250
          },
          "key_as_string": "2017/05/29 00:00:00",
          "key": 1495983600000,
          "doc_count": 6
        }
      ]
    }
  },
  "status": 200
}
```

---

<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:** [December 13, 2016, 1:40pm UTC](https://discuss.elastic.co/t/kibana-fails-to-show-future-date-on-line-chart/68806/5 "2016-12-13T13:40:37Z")

</div>

Hi @YuWatanabe,

Thanks for the detailed report. This sounds like a bug. I've created an issue for it in the Kibana issue tracker on GitHub: [https://github.com/elastic/kibana/issues/9458](https://github.com/elastic/kibana/issues/9458).

If you have a user on GitHub, you may like to subscribe to that issue so you can receive updates. Also, feel free to add any more comments to the issue.

---

<div class="post-metadata">

**Author:** ![YuWatanabe](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yuwatanabe/32/13259_2.png) [@YuWatanabe](https://discuss.elastic.co/u/YuWatanabe)\
**Post date:** [December 13, 2016, 3:04pm UTC](https://discuss.elastic.co/t/kibana-fails-to-show-future-date-on-line-chart/68806/6 "2016-12-13T15:04:47Z")

</div>

Hi Shaunak.

Ok thanks. I will take track of the git hub isaue.

---

<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:** [January 10, 2017, 3:05pm UTC](https://discuss.elastic.co/t/kibana-fails-to-show-future-date-on-line-chart/68806/7 "2017-01-10T15:05:09Z")

</div>

Closed on January 10, 2017, 3:05pm UTC

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