Average of sum(value)

[elasticforme (Sachin)]

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?

[stephenb (Stephen Brown)]

Lens Formula should be

sum(user)/count()

Example with data / bytes

[elasticforme (Sachin)]

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