# Aggregate by sum and avg in visualization

**URL:** <https://discuss.elastic.co/t/aggregate-by-sum-and-avg-in-visualization/328534>\
**Category:** Kibana\
**Tags:** docker, lens\
**Created:** [March 26, 2023, 1:10am UTC](https://discuss.elastic.co/t/aggregate-by-sum-and-avg-in-visualization/328534 "2023-03-26T01:10:17Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Stratoula\_Kalafateli](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stratoula_kalafateli/32/70923_2.png) [@Stratoula\_Kalafateli](https://discuss.elastic.co/u/Stratoula_Kalafateli)\
**Post date:** [March 27, 2023, 6:41am UTC](https://discuss.elastic.co/t/aggregate-by-sum-and-avg-in-visualization/328534/2 "2023-03-27T06:41:33Z")

</div>

Hey, I am not sure I get your configuration correctly but I understand that you have a visualization with a breakdown and you want to sum. This can be done in Lens with the collapse by setting

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/1/b186ece290718ba0a3d5587f31332877eeb3523e.png)

Unfortunately you can't divide with a number though, we don't support formula on the breakdown dimension.

---

_[View the full topic](https://discuss.elastic.co/t/aggregate-by-sum-and-avg-in-visualization/328534)._