# Average of sum(value)

**URL:** <https://discuss.elastic.co/t/average-of-sum-value/330685>\
**Category:** Kibana\
**Created:** [April 24, 2023, 8:31pm UTC](https://discuss.elastic.co/t/average-of-sum-value/330685 "2023-04-24T20:31:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [April 24, 2023, 8:31pm UTC](https://discuss.elastic.co/t/average-of-sum-value/330685/1 "2023-04-24T20:31:19Z")

</div>

I am running a ingestion and records comes every 15 min

one of the field is integer #user  
value might be 1, 2,3 or what ever.

what I am trying to do is average of sum ( users) per hour

for example  
rec1 - 10:00am { user: 1}  
rec2 - 10:15am { user: 5 }  
rec3 - 10:30am { user: 5}  
rec 4 - 10:45am { user: 1}

now average (sum (user)) should be = (1+5+5+1 / 4) = 3

how do I get that in kibana?

---

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [April 24, 2023, 8:57pm UTC](https://discuss.elastic.co/t/average-of-sum-value/330685/2 "2023-04-24T20:57:55Z")

</div>

Lens Formula should be

`sum(user)/count()`

Example with data / bytes

 ![Screenshot 2023-04-24 at 1.58.44 PM](https://us1.discourse-cdn.com/elastic/original/3X/9/e/9e2bd07967caa70c11d9e6ea9304e22791ed599a.png)

---

<div class="post-metadata">

**Author:** ![elasticforme](https://avatars.discourse-cdn.com/v4/letter/e/f05b48/32.png) [@elasticforme](https://discuss.elastic.co/u/elasticforme)\
**Post date:** [April 24, 2023, 9:09pm UTC](https://discuss.elastic.co/t/average-of-sum-value/330685/3 "2023-04-24T21:09:50Z")

</div>

didn't know about this count() that you can use. Great. Thanks

---

<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:** [May 22, 2023, 9:09pm UTC](https://discuss.elastic.co/t/average-of-sum-value/330685/4 "2023-05-22T21:09:55Z")

</div>

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