# How to configure Daily Average Sum Calculation in Lens? **URL:** \ **Category:** Kibana\ **Tags:** lens\ **Created:** [February 11, 2025, 9:51pm UTC](https://discuss.elastic.co/t/how-to-configure-daily-average-sum-calculation-in-lens/374387 "2025-02-11T21:51:32Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Rafael\_Mendonca](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rafael_mendonca/32/141301_2.png) [@Rafael\_Mendonca](https://discuss.elastic.co/u/Rafael_Mendonca)\ **Post date:** [February 11, 2025, 9:51pm UTC](https://discuss.elastic.co/t/how-to-configure-daily-average-sum-calculation-in-lens/374387/1 "2025-02-11T21:51:32Z")
I have a "Data Table" visualization configured, where I sum the daily average of a specific value, as shown in the image below. ![kibana](https://us1.discourse-cdn.com/elastic/original/3X/3/5/35f7d7202841dac37d589fb44d2776bd665b78d2.png) Now, I'm trying to recreate this view in Lens, but I can't achieve the same calculation, even using a formula. How can I do it? ---
**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\ **Post date:** [February 12, 2025, 8:35am UTC](https://discuss.elastic.co/t/how-to-configure-daily-average-sum-calculation-in-lens/374387/2 "2025-02-12T08:35:38Z")
The image was never uploaded. Can you also share what you tried in Lens that did not work and which version? ---
**Author:** ![Rafael\_Mendonca](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rafael_mendonca/32/141301_2.png) [@Rafael\_Mendonca](https://discuss.elastic.co/u/Rafael_Mendonca)\ **Post date:** [February 12, 2025, 4:41pm UTC](https://discuss.elastic.co/t/how-to-configure-daily-average-sum-calculation-in-lens/374387/3 "2025-02-12T16:41:53Z")
Sorry, I updated the post with the image now. The version of Kibana I use is 8.11.3.