# Relative value calculation and visualization in Kibana

**URL:** <https://discuss.elastic.co/t/relative-value-calculation-and-visualization-in-kibana/246927>\
**Category:** Kibana\
**Created:** [August 31, 2020, 8:46am UTC](https://discuss.elastic.co/t/relative-value-calculation-and-visualization-in-kibana/246927 "2020-08-31T08:46:52Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hung\_The](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hung_the/32/62849_2.png) [@Hung\_The](https://discuss.elastic.co/u/Hung_The)\
**Post date:** [August 31, 2020, 8:46am UTC](https://discuss.elastic.co/t/relative-value-calculation-and-visualization-in-kibana/246927/1 "2020-08-31T08:46:53Z")

</div>

Hi All,  
I am new to Kibana and ES. I get some issues with how to display our data in relative fashion.  
I want to get the minimum of queried result and divided all other values in the queried result to that minimum so we can get relative comparison with related to minimum value of result.  
Anybody get some ideas on this?  
Thank you,

---

<div class="post-metadata">

**Author:** ![ppisljar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ppisljar/32/11588_2.png) [@ppisljar](https://discuss.elastic.co/u/ppisljar)\
**Post date:** [September 2, 2020, 8:45am UTC](https://discuss.elastic.co/t/relative-value-calculation-and-visualization-in-kibana/246927/2 "2020-09-02T08:45:13Z")

</div>

I don't fully understand your question.

could you provide your sample dataset (how documents in your index look) and a sample result you are looking for, together with how you calculate those values ?

if you want to do calculations based on different aggregations, that is possible inside TSVB (time series visual builder) kibana visualization tool.

---

<div class="post-metadata">

**Author:** ![Hung\_The](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hung_the/32/62849_2.png) [@Hung\_The](https://discuss.elastic.co/u/Hung_The)\
**Post date:** [September 4, 2020, 1:21am UTC](https://discuss.elastic.co/t/relative-value-calculation-and-visualization-in-kibana/246927/3 "2020-09-04T01:21:29Z")

</div>

Hi, Thank you for your reply.  
My data is like this :

```auto
    { id="GTX1080", perf=1.8}
    { id="GTX1070", perf=1.6}
    { id="GTX1060", perf=1.3}
    { id="GTX1050", perf=0.9}
    { id="GTX2080", perf=2.2}
    { id="GTX2070", perf=1.9}

```

Now in the normal bar display it will be like  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/d/4def2233a4e880c130d9ec6280ac9a83e45253af.png)  
What i want to do is that i want to find the minimum value of perf, in here is 0.9, then scale all other value based on it. The result will be like below  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/5/250537abc348e071fb939f9f4e4d7e760fd51cc0.png)

---

<div class="post-metadata">

**Author:** ![Hung\_The](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hung_the/32/62849_2.png) [@Hung\_The](https://discuss.elastic.co/u/Hung_The)\
**Post date:** [September 10, 2020, 3:44am UTC](https://discuss.elastic.co/t/relative-value-calculation-and-visualization-in-kibana/246927/4 "2020-09-10T03:44:18Z")

</div>

@ppisljar I have updated my post, can you help me to check it. Thanks

---

<div class="post-metadata">

**Author:** ![ppisljar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ppisljar/32/11588_2.png) [@ppisljar](https://discuss.elastic.co/u/ppisljar)\
**Post date:** [September 10, 2020, 12:42pm UTC](https://discuss.elastic.co/t/relative-value-calculation-and-visualization-in-kibana/246927/5 "2020-09-10T12:42:33Z")

</div>

that should be possible in TSVB (time series visual builder).

use math aggregation to combine your min aggregation with your histogram aggregation

---

<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:** [October 8, 2020, 12:42pm UTC](https://discuss.elastic.co/t/relative-value-calculation-and-visualization-in-kibana/246927/6 "2020-10-08T12:42:37Z")

</div>

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