# Date Range series in Kibana: how to fit the global date range filter of kibana?

**URL:** <https://discuss.elastic.co/t/date-range-series-in-kibana-how-to-fit-the-global-date-range-filter-of-kibana/247107>\
**Category:** Kibana\
**Created:** [September 1, 2020, 2:36pm UTC](https://discuss.elastic.co/t/date-range-series-in-kibana-how-to-fit-the-global-date-range-filter-of-kibana/247107 "2020-09-01T14:36:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dao](https://avatars.discourse-cdn.com/v4/letter/d/a6a055/32.png) [@dao](https://discuss.elastic.co/u/dao)\
**Post date:** [September 1, 2020, 2:36pm UTC](https://discuss.elastic.co/t/date-range-series-in-kibana-how-to-fit-the-global-date-range-filter-of-kibana/247107/1 "2020-09-01T14:36:16Z")

</div>

I have created this date range filter on a visualization using the [acceptable date formats](https://www.elastic.co/guide/en/elasticsearch/reference/7.8/common-options.html#date-math)

here is my first draft  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/3/738bcc68990ea86452078e6f8370750e60f1db18.png)

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

OK, I am happy if I stick to now. But if I go back in time in my global filter, then the visualization is empty. This is normal behavior as we used `now` as reference.

How can I match the ranges to the upper bound of the global date range filter?  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/e/8e3093bece1ea7f117a20dadd105bdff5101906c.png)

I'd like to use a variable that is the upper bound (`2020-06-30 14:34:42`) in the different ranges

best

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [September 1, 2020, 5:36pm UTC](https://discuss.elastic.co/t/date-range-series-in-kibana-how-to-fit-the-global-date-range-filter-of-kibana/247107/2 "2020-09-01T17:36:21Z")

</div>

This isn't currently supported, and I couldn't find an issue describing this. What syntax would you expect to use to indicate these variables?

---

<div class="post-metadata">

**Author:** ![dao](https://avatars.discourse-cdn.com/v4/letter/d/a6a055/32.png) [@dao](https://discuss.elastic.co/u/dao)\
**Post date:** [September 1, 2020, 6:55pm UTC](https://discuss.elastic.co/t/date-range-series-in-kibana-how-to-fit-the-global-date-range-filter-of-kibana/247107/3 "2020-09-01T18:55:58Z")

</div>

You could have 2 extra keyword, one for the upper bound and one for the lower bound. and still the `now` keyword. Of course, it is only for kibana, not for elasticsearch (`now` is a keyword for elasticsearch)

So kibana should process those 2 keywords to replace them with the actual values before requesting.

In the mean time, how can I display bars with a shift in time for each bar? do you have an alternative?

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [September 1, 2020, 7:59pm UTC](https://discuss.elastic.co/t/date-range-series-in-kibana-how-to-fit-the-global-date-range-filter-of-kibana/247107/4 "2020-09-01T19:59:14Z")

</div>

This is not supported using the Date Range aggregation. I created an issue for you [https://github.com/elastic/kibana/issues/76433](https://github.com/elastic/kibana/issues/76433)

I think you can do this using Vega. I recently wrote new tutorials for how to do this, and here's the reference: [https://www.elastic.co/guide/en/kibana/current/vega-reference.html#vega-queries](https://www.elastic.co/guide/en/kibana/current/vega-reference.html#vega-queries)

---

<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:** [September 29, 2020, 7:59pm UTC](https://discuss.elastic.co/t/date-range-series-in-kibana-how-to-fit-the-global-date-range-filter-of-kibana/247107/5 "2020-09-29T19:59:30Z")

</div>

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