# Rollup jobs: Averages are Sums, ok! How can I visualize the actual averages in a Line Graph?

**URL:** <https://discuss.elastic.co/t/rollup-jobs-averages-are-sums-ok-how-can-i-visualize-the-actual-averages-in-a-line-graph/201263>\
**Category:** Kibana\
**Created:** [September 26, 2019, 3:38pm UTC](https://discuss.elastic.co/t/rollup-jobs-averages-are-sums-ok-how-can-i-visualize-the-actual-averages-in-a-line-graph/201263 "2019-09-26T15:38:34Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)\
**Post date:** [September 30, 2019, 2:23pm UTC](https://discuss.elastic.co/t/rollup-jobs-averages-are-sums-ok-how-can-i-visualize-the-actual-averages-in-a-line-graph/201263/2 "2019-09-30T14:23:51Z")

</div>

Hi @jrubio,

thanks for reaching out. To handle rollups correctly in visualizations, it's necessary to create a rollup index pattern. If you go into Management \> Index patterns and press "Create new index pattern" you should be able to select rollup index pattern from the context menu. This will tell Kibana to do the conversion described in [ES 6.3.2 Rollup avg metric does a sum instead?](https://discuss.elastic.co/t/es-6-3-2-rollup-avg-metric-does-a-sum-instead/146875). It will also hide the technical field names like `usage_average.avg.value` and show you the regular field names which makes it possible to create visualizations as if the data isn't even rolled up - with the only difference that the aggregations you didn't activate in your rollup configuration will be greyed out.

Could you check whether the index pattern you are working with is created as rollup index pattern?  
 ![21](https://us1.discourse-cdn.com/elastic/original/3X/5/7/57aba06f75891a648cf4a44bd69ed1a8c2b882c8.png)

---

_[View the full topic](https://discuss.elastic.co/t/rollup-jobs-averages-are-sums-ok-how-can-i-visualize-the-actual-averages-in-a-line-graph/201263)._
