# Multiplication of series in Kibana

**URL:** <https://discuss.elastic.co/t/multiplication-of-series-in-kibana/266006>\
**Category:** Kibana\
**Created:** [March 2, 2021, 6:44pm UTC](https://discuss.elastic.co/t/multiplication-of-series-in-kibana/266006 "2021-03-02T18:44:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shailendra\_Chauhan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shailendra_chauhan/32/84838_2.png) [@Shailendra\_Chauhan](https://discuss.elastic.co/u/Shailendra_Chauhan)\
**Post date:** [March 2, 2021, 6:44pm UTC](https://discuss.elastic.co/t/multiplication-of-series-in-kibana/266006/1 "2021-03-02T18:44:10Z")

</div>

Hi,  
Background: For application monitoring I have various monitors that pings several component periodically that makes up a complete application/system. Each of these individual ping in inserted into elasticsearch with information if a particular run of monitor resulted in SUCCESS or FAIL alongside other details.  
So let's say if I have 3 monitors MON1, MON2, MON3 executing every 5 minutes (all these monitors must result is SUCCESS for system to be 100% up) and result in following data.

| timestamp | monitor | result |
| --- | --- | --- |
| t1 | MON1 | SUCCESS |
| t2 | MON2 | FAIL |
| t3 | MON1 | SUCCESS |
| t4 | MON3 | SUCCESS |
| t5 | MON2 | FAIL |
| t5 | MON1 | SUCCESS |
| t6 | MON2 | SUCCESS |

What I am able to do so far is using TSVB visualization is to calculate the percentage of uptime grouped by monitor which gives me 3 percentage(in the given example).  
My need is to then multiply these 3 individual percentages (not average) to have one number as the overall uptime of the system. So if a time range is chosen from t2 to t5 then over all uptime should be 0%.  
Any help is much appreciated!

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [March 5, 2021, 11:49am UTC](https://discuss.elastic.co/t/multiplication-of-series-in-kibana/266006/2 "2021-03-05T11:49:32Z")

</div>

Math aggregation in TSVB should allow you to multiply the results of all these 3, but you won't be able to do it by Group, you'll need to use a 3x Filter aggregations cause it works with aggregations that return 1 value instead of multiple.

---

<div class="post-metadata">

**Author:** ![Shailendra\_Chauhan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shailendra_chauhan/32/84838_2.png) [@Shailendra\_Chauhan](https://discuss.elastic.co/u/Shailendra_Chauhan)\
**Post date:** [March 8, 2021, 1:25pm UTC](https://discuss.elastic.co/t/multiplication-of-series-in-kibana/266006/3 "2021-03-08T13:25:08Z")

</div>

Thank you Marius, this solved it.

---

<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 5, 2021, 1:26pm UTC](https://discuss.elastic.co/t/multiplication-of-series-in-kibana/266006/4 "2021-04-05T13:26:00Z")

</div>

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