# Range query for date in filter ratio - TSVB

**URL:** <https://discuss.elastic.co/t/range-query-for-date-in-filter-ratio-tsvb/272900>\
**Category:** Kibana\
**Created:** [May 13, 2021, 10:16am UTC](https://discuss.elastic.co/t/range-query-for-date-in-filter-ratio-tsvb/272900 "2021-05-13T10:16:09Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ErSumit](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ersumit/32/88708_2.png) [@ErSumit](https://discuss.elastic.co/u/ErSumit)\
**Post date:** [May 13, 2021, 10:16am UTC](https://discuss.elastic.co/t/range-query-for-date-in-filter-ratio-tsvb/272900/1 "2021-05-13T10:16:09Z")

</div>

I want to calculate percentage of sales between offer period. I have multiple stores having offers running during multiple dates. I tried with TSVB, filter ratio as in below image. I'm getting 0% even having data for condition

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/a/7a592f161298f48be0cb9123baadb188cba050f8.png)

```auto
{
    "sale_id": "NAGJS49i493",
    "sale_date": "2021-01-01T17:15:20.000-0500Z",
    "offer_start_dt": "2021-01-01T10:15:20.000-0500Z",
    "offer_end_dt": "2021-01-01T17:15:20.000-0500Z", 
   ...
}

```

Please help

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [May 20, 2021, 6:05pm UTC](https://discuss.elastic.co/t/range-query-for-date-in-filter-ratio-tsvb/272900/2 "2021-05-20T18:05:32Z")

</div>

> [@ErSumit](#):
>
> I have multiple stores having offers running during multiple dates

Hello,

How is your data defined? In one index pattern altogether? Can you see the data in timeseries visualization?

Thanks  
Bhavya

---

<div class="post-metadata">

**Author:** ![ErSumit](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ersumit/32/88708_2.png) [@ErSumit](https://discuss.elastic.co/u/ErSumit)\
**Post date:** [May 20, 2021, 7:39pm UTC](https://discuss.elastic.co/t/range-query-for-date-in-filter-ratio-tsvb/272900/3 "2021-05-20T19:39:44Z")

</div>

yes bhavyarm  
All data is in a index

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [May 20, 2021, 7:46pm UTC](https://discuss.elastic.co/t/range-query-for-date-in-filter-ratio-tsvb/272900/4 "2021-05-20T19:46:11Z")

</div>

can you see the data as visualizations in other tabs of TSVB?

Thanks  
Bhavya

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [May 20, 2021, 7:46pm UTC](https://discuss.elastic.co/t/range-query-for-date-in-filter-ratio-tsvb/272900/5 "2021-05-20T19:46:45Z")

</div>

@Marius_Dragomir thanks!

---

<div class="post-metadata">

**Author:** ![ErSumit](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ersumit/32/88708_2.png) [@ErSumit](https://discuss.elastic.co/u/ErSumit)\
**Post date:** [May 20, 2021, 8:25pm UTC](https://discuss.elastic.co/t/range-query-for-date-in-filter-ratio-tsvb/272900/6 "2021-05-20T20:25:53Z")

</div>

Thanks @bhavyarm for reply 😃

Yes, all data is in a index and hence a index pattern. I've mentioned index pattern in the 'Panel options' section and also set data time range mode to 'Entire time range'

All chart modes display 0 value, any difference I can observe is few dots at zero on time series graph.

I just spent some more time to try few combinations, but no luck  
While I change `Numerator: offer_start_dt: *` & `Denominator: *` , I get values in all of the tabs.  
I can see data is available via discover tab.

---

<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:** [June 17, 2021, 8:26pm UTC](https://discuss.elastic.co/t/range-query-for-date-in-filter-ratio-tsvb/272900/7 "2021-06-17T20:26:37Z")

</div>

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