# Kibana - Average based on two fields value

**URL:** <https://discuss.elastic.co/t/kibana-average-based-on-two-fields-value/231766>\
**Category:** Kibana\
**Created:** [May 8, 2020, 3:56pm UTC](https://discuss.elastic.co/t/kibana-average-based-on-two-fields-value/231766 "2020-05-08T15:56:09Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![JoseLuisEzquerro](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joseluisezquerro/32/63524_2.png) [@JoseLuisEzquerro](https://discuss.elastic.co/u/JoseLuisEzquerro)\
**Post date:** [May 8, 2020, 3:56pm UTC](https://discuss.elastic.co/t/kibana-average-based-on-two-fields-value/231766/1 "2020-05-08T15:56:09Z")

</div>

Hello all,

I'm using Kibana 6.8.2, and I have an index with next parameters

```auto
* message_total_size
* message_total_count
* date
* country

```

I want to make a Vertical Bar visualization to show the average message size per day (using date histogram), but I cannot find a way to make the division like: `message_total_size/message_total_count`

I tried with the Average aggregation, but it doesn't work form in this case (at least I cannot see how), because is making the average based on the number of documents in the index.

I'd appreciate any help, thanks 🙂

Regards,  
JL

---

<div class="post-metadata">

**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\
**Post date:** [May 8, 2020, 4:29pm UTC](https://discuss.elastic.co/t/kibana-average-based-on-two-fields-value/231766/2 "2020-05-08T16:29:20Z")

</div>

you can use Time Series Visual Builder for this. I loaded in a `6.8.2` new instance the flights sample data and created a chart that renders a ratio between the average distance and the average flight time using the `Bucket Script` aggregation

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

[This blog post](https://www.elastic.co/blog/how-to-display-data-as-a-percentage-in-kibana-visualizations) also covers pretty well the topic of computing ratios in different Kibana applications.

---

<div class="post-metadata">

**Author:** ![JoseLuisEzquerro](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joseluisezquerro/32/63524_2.png) [@JoseLuisEzquerro](https://discuss.elastic.co/u/JoseLuisEzquerro)\
**Post date:** [May 8, 2020, 6:32pm UTC](https://discuss.elastic.co/t/kibana-average-based-on-two-fields-value/231766/3 "2020-05-08T18:32:50Z")

</div>

> [@jsanz](#):
>
> Visual Builder

Hello jsanz,

Thanks a lot for your help! Do you know if you can change the X and Y Axis title, like with Bar Visualizations?

---

<div class="post-metadata">

**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\
**Post date:** [May 11, 2020, 9:26am UTC](https://discuss.elastic.co/t/kibana-average-based-on-two-fields-value/231766/4 "2020-05-11T09:26:47Z")

</div>

I don't think you can do that, my best effort following my last example was to improve units in the y axis and a better layer name that appears in the legend

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

As always, feel free to [open a feature request](https://github.com/elastic/kibana/issues/new?template=Feature_request.md) in our issue tracker, since [I haven't found](https://github.com/elastic/kibana/issues?q=is%3Aissue+label%3AFeature%3ATSVB+axis+title+) anything like this.

---

<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 8, 2020, 9:26am UTC](https://discuss.elastic.co/t/kibana-average-based-on-two-fields-value/231766/5 "2020-06-08T09:26:49Z")

</div>

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