# Dynamic time period in datatable visulisation

**URL:** <https://discuss.elastic.co/t/dynamic-time-period-in-datatable-visulisation/266968>\
**Category:** Kibana\
**Created:** [March 11, 2021, 3:48pm UTC](https://discuss.elastic.co/t/dynamic-time-period-in-datatable-visulisation/266968 "2021-03-11T15:48:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![anjilinga](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anjilinga/32/86010_2.png) [@anjilinga](https://discuss.elastic.co/u/anjilinga)\
**Post date:** [March 11, 2021, 3:48pm UTC](https://discuss.elastic.co/t/dynamic-time-period-in-datatable-visulisation/266968/1 "2021-03-11T15:48:39Z")

</div>

Hi,

How can the Datehistogram period can be configured dynamically. curently the histogram is configured as 1d.  
to see the data for 1 week, the data is displaying in multiple rows. is there any way to display the data as per period selected in a single row for each group.  
to see the summary data for 1 day, 1 week, 1 month and 1 year as a summary instead of multiple rows for the same group by

Regards,

---

<div class="post-metadata">

**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\
**Post date:** [March 22, 2021, 9:32am UTC](https://discuss.elastic.co/t/dynamic-time-period-in-datatable-visulisation/266968/2 "2021-03-22T09:32:35Z")

</div>

Hi, something similart to this can be achieved with a filter aggregation instead: this can allow you to specify a subset of time windows (of the current selected time range) and apply an aggregation of each specific subset of documents.  
I've attached here an example where I've filtered out documents based on KQL filters on the time field.

 ![Screenshot 2021-03-22 at 10.29.19](https://us1.discourse-cdn.com/elastic/original/3X/f/d/fd69b6b24bfd7b56d0f67b9cb29fa8935b094f77.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:** [April 19, 2021, 9:32am UTC](https://discuss.elastic.co/t/dynamic-time-period-in-datatable-visulisation/266968/3 "2021-04-19T09:32:37Z")

</div>

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