# \[DataTable\]The problems about DataTable

**URL:** https://discuss.elastic.co/t/datatable-the-problems-about-datatable/164104
**Category:** Kibana
**Created:** [January 14, 2019, 7:50am UTC](https://discuss.elastic.co/t/datatable-the-problems-about-datatable/164104 "2019-01-14T07:50:35Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![jjwang](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@jjwang](https://discuss.elastic.co/u/jjwang)
#### Post date: [January 14, 2019, 7:50am UTC](https://discuss.elastic.co/t/datatable-the-problems-about-datatable/164104/1 "2019-01-14T07:50:35Z")

</div>

Hi!  
I have two problems about use of DataTable:  
First,When use Avg Aggregation Metric with JSON input,may be the aggregate result is null,then kibana will throws an error:6 of 24 shards failed,as follows:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/8/183f6cd82ec8ecdc308bd3b9523273590074d145.png)  
and is there any solutions.  
Second,When use Date Histogram,the interval will change follows the time range,as follows:I set the interval is 5 minutes,but shows interval is 3 houres.  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/b/ebc42df09d6e2bf3a33a81e15a91ae18b09a9f84.png)  
I hope 5 minutes and is there any solutions.

---

<div class="post-metadata">

### Author: ![Sjaak01](https://avatars.discourse-cdn.com/v4/letter/s/73ab20/32.png) [@Sjaak01](https://discuss.elastic.co/u/Sjaak01)
#### Post date: [January 15, 2019, 7:12am UTC](https://discuss.elastic.co/t/datatable-the-problems-about-datatable/164104/2 "2019-01-15T07:12:41Z")

</div>

Wouldn't it be much easier to apply a filter or query to your table instead of trying to use JSON input?

What is the error you see when hovering over the interval error? Could be that your time range is so long the max. amount of buckets will be exceeded (I think it's 2000 by default, you should be able to change this in the default settings but it might affect performance).

---

<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: [February 12, 2019, 7:12am UTC](https://discuss.elastic.co/t/datatable-the-problems-about-datatable/164104/3 "2019-02-12T07:12:43Z")

</div>

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