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

Elastic Stack Kibana
1

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?

2

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.

Cheers,
Tim