# Using Interval of visual builder

**URL:** <https://discuss.elastic.co/t/using-interval-of-visual-builder/180630>\
**Category:** Kibana\
**Created:** [May 11, 2019, 3:30am UTC](https://discuss.elastic.co/t/using-interval-of-visual-builder/180630 "2019-05-11T03:30:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sahere37](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@sahere37](https://discuss.elastic.co/u/sahere37)\
**Post date:** [May 11, 2019, 3:30am UTC](https://discuss.elastic.co/t/using-interval-of-visual-builder/180630/1 "2019-05-11T03:30:57Z")

</div>

Hi all  
I am using visual builder of kibana to create an visualize for TPS. in the Time series part of kibana I used "Count" aggregation and in Option part I set interval as 1s (because the desire result is number of transaction per second and by setting interval as auto it gives me wrong result), on the other hand in the time range panel of kibana "Last 15 minutes" has been considered. the graph of visual builder results as following which is so dense (show results per 1 second):

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/e/ce426ad32cbb0e61c09bb898c8439c44882854ee.png)  
while in the "Line" type visualize when i defined interval of X-Axis as "Second" it calculate the correct TPS (count the results per 1 second) and also show the results sparser (in the case of time range "Last 15 minutes" shows result per 5 seconds) as following:

![image](https://us1.discourse-cdn.com/elastic/original/3X/4/d/4d2fcef768ff55a6efbc7d36f29c2421c2d9759c.png)

how can i handle this issue in visual builder case so that count the result per 1 second but show them automatically sparser based on the time range

---

<div class="post-metadata">

**Author:** ![sahere37](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@sahere37](https://discuss.elastic.co/u/sahere37)\
**Post date:** [May 13, 2019, 9:46am UTC](https://discuss.elastic.co/t/using-interval-of-visual-builder/180630/2 "2019-05-13T09:46:25Z")

</div>

any advice will be so appreciated

---

<div class="post-metadata">

**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\
**Post date:** [May 13, 2019, 4:33pm UTC](https://discuss.elastic.co/t/using-interval-of-visual-builder/180630/3 "2019-05-13T16:33:02Z")

</div>

@sahere37

I'm pretty sure this rescaling is not available in the time series visual builder (I might be wrong).

I would create an enhancement request here: [https://github.com/elastic/kibana/issues/new](https://github.com/elastic/kibana/issues/new)

---

<div class="post-metadata">

**Author:** ![sahere37](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@sahere37](https://discuss.elastic.co/u/sahere37)\
**Post date:** [May 14, 2019, 3:33am UTC](https://discuss.elastic.co/t/using-interval-of-visual-builder/180630/4 "2019-05-14T03:33:53Z")

</div>

many thanks

---

<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 11, 2019, 3:33am UTC](https://discuss.elastic.co/t/using-interval-of-visual-builder/180630/5 "2019-06-11T03:33:54Z")

</div>

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