# Showing tps in TSVB in kibana

**URL:** <https://discuss.elastic.co/t/showing-tps-in-tsvb-in-kibana/286926>\
**Category:** Kibana\
**Created:** [October 17, 2021, 10:56am UTC](https://discuss.elastic.co/t/showing-tps-in-tsvb-in-kibana/286926 "2021-10-17T10:56:37Z")\
**Posts on this page:** 4\
**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:** [October 17, 2021, 10:56am UTC](https://discuss.elastic.co/t/showing-tps-in-tsvb-in-kibana/286926/1 "2021-10-17T10:56:37Z")

</div>

Hi all,  
I am using kibana version 7.13.1 TSVB visualize to show TPS (COUNT per Second). the output graph is as following in "Last 15 minutes" in the case of setting "Override index pattern" No and using auto interval (according following image, TPS range is about 8-28):

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

Selecting different time range lead to different TPS value whereas non of these values are correct, for example using "Last 30 minutes" (TPS range is about 40-70 according to below image):

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/8/c/8c4b352ff91bbb74a389948396072a78759d493b.png)

Both of the above TPS range are wrong and auto interval leads to incorrect TPS value. The real TPS in the case of setting "interval" in "Override index pattern" to "1s" is as following ( the real TPS is about 0-9) which in any time range is similar :

figure: in the case of last 1 minute:

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

figure in the case of last 15 minutes:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/a/ba09e4345b3152833c856e2d650d20016e07ab4d.jpeg)

In these cases, TPS value is correct but kibana visualize show many data which is not user friendly. How can set the settings so that shows true TPS in a user friendly view?  
Any advise will be so appreciated. Regards.

---

<div class="post-metadata">

**Author:** ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)\
**Post date:** [October 20, 2021, 11:33am UTC](https://discuss.elastic.co/t/showing-tps-in-tsvb-in-kibana/286926/2 "2021-10-20T11:33:40Z")

</div>

Hi there, I think my response from this post might help you here: [Showing TPS on line visulaize - #2 by Marta\_Bondyra](https://discuss.elastic.co/t/showing-tps-on-line-visulaize/286898/2)

---

<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:** [November 1, 2021, 5:19am UTC](https://discuss.elastic.co/t/showing-tps-in-tsvb-in-kibana/286926/3 "2021-11-01T05:19:27Z")

</div>

Hi Dear Marta\_Bondyra,

The issue has been solved by adding "params.count / (params.\_interval / 1000)" expression in math aggregation.

Regards

---

<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:** [November 29, 2021, 5:19am UTC](https://discuss.elastic.co/t/showing-tps-in-tsvb-in-kibana/286926/4 "2021-11-29T05:19:41Z")

</div>

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