# Bar graph - Flat line for sum of average combined with date histogram?

**URL:** <https://discuss.elastic.co/t/bar-graph-flat-line-for-sum-of-average-combined-with-date-histogram/144799>\
**Category:** Kibana\
**Created:** [August 17, 2018, 12:51am UTC](https://discuss.elastic.co/t/bar-graph-flat-line-for-sum-of-average-combined-with-date-histogram/144799 "2018-08-17T00:51:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sjaak01](https://avatars.discourse-cdn.com/v4/letter/s/73ab20/32.png) [@Sjaak01](https://discuss.elastic.co/u/Sjaak01)\
**Post date:** [August 17, 2018, 12:51am UTC](https://discuss.elastic.co/t/bar-graph-flat-line-for-sum-of-average-combined-with-date-histogram/144799/1 "2018-08-17T00:51:32Z")

</div>

Hi,

I have a bar graph with a data histogram and and a sum to show me a value per 24 hours. So when I select 10 days of data I get 10 bars.

Now I want to add a flat line that shows the average of the sum over whatever data range I picked from the time picker so I can see per day values along with an average value over time.

I tried various aggregations but I'm not getting the results I need.

Is there a way to do this?

---

<div class="post-metadata">

**Author:** ![timroes](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/timroes/32/19712_2.png) [@timroes](https://discuss.elastic.co/u/timroes)\
**Post date:** [August 17, 2018, 6:36am UTC](https://discuss.elastic.co/t/bar-graph-flat-line-for-sum-of-average-combined-with-date-histogram/144799/2 "2018-08-17T06:36:03Z")

</div>

This is currently unfortunately not possible in classical charts. The only way I can think of currently is using timelion and it's `aggregate` function to achieve that result.

You can find an introduction into timelion in [this blog post](https://www.timroes.de/2017/08/02/timelion-tutorial-from-zero-to-hero/).

Cheers,  
Tim

---

<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:** [September 14, 2018, 6:36am UTC](https://discuss.elastic.co/t/bar-graph-flat-line-for-sum-of-average-combined-with-date-histogram/144799/3 "2018-09-14T06:36:05Z")

</div>

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