# Compare average and individual dynamics (in TSVB)

**URL:** <https://discuss.elastic.co/t/compare-average-and-individual-dynamics-in-tsvb/206191>\
**Category:** Kibana\
**Created:** [November 1, 2019, 4:36pm UTC](https://discuss.elastic.co/t/compare-average-and-individual-dynamics-in-tsvb/206191 "2019-11-01T16:36:11Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anne\_Kim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anne_kim/32/47196_2.png) [@Anne\_Kim](https://discuss.elastic.co/u/Anne_Kim)\
**Post date:** [November 1, 2019, 4:36pm UTC](https://discuss.elastic.co/t/compare-average-and-individual-dynamics-in-tsvb/206191/1 "2019-11-01T16:36:11Z")

</div>

Hi there,

I've created a TSVB-visualization that plots the dynamics of an average rang (of all players) and individual rangs. It looks like that:

 ![](https://us1.discourse-cdn.com/elastic/original/3X/6/e/6ed2b3681683c0b81430d57e2cda500a49a815bf.png)  
This visualization is used in a dashboard filtered by a single player (i.e. a player's ID is indicated so that all data & graphs for this player are shown). And when the TSVB becomes also filtered, a "common" average value coincides with the "personal" one (see a screenshot).  
 ![](https://us1.discourse-cdn.com/elastic/original/3X/c/9/c9de77ff74af05b00ee7ee5938e55d6fae2c7323.png)  
In TSVB "`Panel options`" there is "`Ignore global filter`", but this option conserves the values for ALL players. How can I "freeze" a common average value and then compare it with the one of a specified player?

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [November 1, 2019, 5:30pm UTC](https://discuss.elastic.co/t/compare-average-and-individual-dynamics-in-tsvb/206191/2 "2019-11-01T17:30:44Z")

</div>

Set `Panel filter` to the desired player name under the TSVB `Panel options` tab for the TSVB chart that ignores global filters. This will ensure the TSVB chart always displays stats for a single player regardless of filter settings. This TSVB chart can then be used to to compare other players against the specified player from the `Panel filter`.

 ![51%20AM](https://us1.discourse-cdn.com/elastic/original/3X/3/c/3cf2dc987fb8733e5cc201cf6bb59abc58699bc0.png)

---

<div class="post-metadata">

**Author:** ![Anne\_Kim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anne_kim/32/47196_2.png) [@Anne\_Kim](https://discuss.elastic.co/u/Anne_Kim)\
**Post date:** [November 4, 2019, 7:56am UTC](https://discuss.elastic.co/t/compare-average-and-individual-dynamics-in-tsvb/206191/3 "2019-11-04T07:56:12Z")

</div>

Actually the question is a bit different: how to always display a common average value? As for a player name filter, it can be set in dashboard. I think that it's possible to add a scripted field calculating an average value to the index, but it can be quite expense.

---

<div class="post-metadata">

**Author:** ![Anne\_Kim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anne_kim/32/47196_2.png) [@Anne\_Kim](https://discuss.elastic.co/u/Anne_Kim)\
**Post date:** [November 12, 2019, 2:33pm UTC](https://discuss.elastic.co/t/compare-average-and-individual-dynamics-in-tsvb/206191/5 "2019-11-12T14:33:24Z")

</div>

So are there any ideas? I need to ensure the TSVB chart always displays stats for an average value regardless of filter settings. Then I want to compare it with some player

---

<div class="post-metadata">

**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\
**Post date:** [November 12, 2019, 2:52pm UTC](https://discuss.elastic.co/t/compare-average-and-individual-dynamics-in-tsvb/206191/6 "2019-11-12T14:52:18Z")

</div>

Then just set "ignore global filter" to yes and your TSVB will ignore filters

---

<div class="post-metadata">

**Author:** ![Anne\_Kim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anne_kim/32/47196_2.png) [@Anne\_Kim](https://discuss.elastic.co/u/Anne_Kim)\
**Post date:** [November 12, 2019, 3:03pm UTC](https://discuss.elastic.co/t/compare-average-and-individual-dynamics-in-tsvb/206191/7 "2019-11-12T15:03:37Z")

</div>

In that case I get a vizualization with both average value and players' values. And I need to hold only an average value

---

<div class="post-metadata">

**Author:** ![Anne\_Kim](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anne_kim/32/47196_2.png) [@Anne\_Kim](https://discuss.elastic.co/u/Anne_Kim)\
**Post date:** [December 5, 2019, 10:31am UTC](https://discuss.elastic.co/t/compare-average-and-individual-dynamics-in-tsvb/206191/8 "2019-12-05T10:31:30Z")

</div>

The solution is to build 2 corresponding visualizations and to place them near each other

---

<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:** [January 2, 2020, 10:31am UTC](https://discuss.elastic.co/t/compare-average-and-individual-dynamics-in-tsvb/206191/9 "2020-01-02T10:31:32Z")

</div>

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