# Kibana - aggregation in graphs (average number of things per bucket)

**URL:** <https://discuss.elastic.co/t/kibana-aggregation-in-graphs-average-number-of-things-per-bucket/311291>\
**Category:** Kibana\
**Created:** [August 3, 2022, 10:29am UTC](https://discuss.elastic.co/t/kibana-aggregation-in-graphs-average-number-of-things-per-bucket/311291 "2022-08-03T10:29:01Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![devon.thomson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/devon.thomson/32/85468_2.png) [@devon.thomson](https://discuss.elastic.co/u/devon.thomson)\
**Post date:** [August 3, 2022, 4:23pm UTC](https://discuss.elastic.co/t/kibana-aggregation-in-graphs-average-number-of-things-per-bucket/311291/2 "2022-08-03T16:23:09Z")

</div>

Hi @RonGros , is your data [denormalized](https://discuss.elastic.co/t/denormalized-data-vs-joins/181041)? If it is denormalized, I.E each row represents one `time` one `person` watched one `movie`, you can easily bucket by date in [Lens](https://www.elastic.co/guide/en/kibana/current/lens.html), then unique count of `name` would be the number of people who saw a movie in that time period. If you're calculating an average, you'd need to calculate it over multiple buckets, whereas a graph would show a value _per_ bucket, so I'm not exactly sure what the average you're looking for is.

---

_[View the full topic](https://discuss.elastic.co/t/kibana-aggregation-in-graphs-average-number-of-things-per-bucket/311291)._