# Average Line Chart

**URL:** <https://discuss.elastic.co/t/average-line-chart/162601>\
**Category:** Kibana\
**Created:** [January 2, 2019, 6:57am UTC](https://discuss.elastic.co/t/average-line-chart/162601 "2019-01-02T06:57:15Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anup\_Kurup](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anup_kurup/32/44174_2.png) [@Anup\_Kurup](https://discuss.elastic.co/u/Anup_Kurup)\
**Post date:** [January 2, 2019, 6:57am UTC](https://discuss.elastic.co/t/average-line-chart/162601/1 "2019-01-02T06:57:15Z")

</div>

Hi,  
I have documents containing feedback data like **user, rating(1,2,3,4,5), date**. I want to create a line chart where the x-axis will be date and there will 2 line charts one shows the average feedback on that particular dates and one line will show the count of feedbacks on that date. I am using Kibana 5 and I am using Line Chart for this.

Thanks  
Anup

---

<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:** [January 7, 2019, 2:50pm UTC](https://discuss.elastic.co/t/average-line-chart/162601/2 "2019-01-07T14:50:27Z")

</div>

You need to add 2 metrics in a Line chart. One showing Average on the Rating field and another one showing the Count.

---

<div class="post-metadata">

**Author:** ![Anup\_Kurup](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anup_kurup/32/44174_2.png) [@Anup\_Kurup](https://discuss.elastic.co/u/Anup_Kurup)\
**Post date:** [January 7, 2019, 3:07pm UTC](https://discuss.elastic.co/t/average-line-chart/162601/3 "2019-01-07T15:07:47Z")

</div>

Hi Marius,  
I have done that but it is showing average based on ratings received on that particular day. I want the average of all the ratings received in tht selected time period. You can check the screenshot.  
Even if it is not possible charts is there any other way to show the average for last 6 months, last 1 month and last 1 week in data table.

Regarda ![Screenshot_20190107-203450](https://us1.discourse-cdn.com/elastic/original/3X/f/6/f60108ec5c1cf4bd179e7bf091b83910937d0fd7.jpeg)

---

<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:** [January 7, 2019, 3:28pm UTC](https://discuss.elastic.co/t/average-line-chart/162601/4 "2019-01-07T15:28:20Z")

</div>

In this case you might want to switch to Visual Builder and use the Math aggregation. Just replace the `bytes` from my example with `rating`

![test](https://us1.discourse-cdn.com/elastic/original/3X/8/2/82f014d62f13e07c87f569f39989388c1d6a39ee.png)

---

<div class="post-metadata">

**Author:** ![Anup\_Kurup](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/anup_kurup/32/44174_2.png) [@Anup\_Kurup](https://discuss.elastic.co/u/Anup_Kurup)\
**Post date:** [January 7, 2019, 3:45pm UTC](https://discuss.elastic.co/t/average-line-chart/162601/5 "2019-01-07T15:45:59Z")

</div>

Hi,  
I just tried based on your example but I m not getting Math under aggregation. I m using kibana 6.x.

Thanks

---

<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:** [February 4, 2019, 3:46pm UTC](https://discuss.elastic.co/t/average-line-chart/162601/6 "2019-02-04T15:46:56Z")

</div>

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