# How to find the Average number of Calls per Hour?

**URL:** <https://community.amazonquick.com/t/how-to-find-the-average-number-of-calls-per-hour/11708>\
**Category:** Q&A\
**Tags:** calculations, analysis, quick-sight\
**Created:** [March 30, 2023, 9:20pm UTC](https://community.amazonquick.com/t/how-to-find-the-average-number-of-calls-per-hour/11708 "2023-03-30T21:20:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![manbig](https://avatars.discourse-cdn.com/v4/letter/m/8baadc/32.png) [@manbig](https://community.amazonquick.com/u/manbig)\
**Post date:** [March 30, 2023, 9:20pm UTC](https://community.amazonquick.com/t/how-to-find-the-average-number-of-calls-per-hour/11708/1 "2023-03-30T21:20:20Z")

</div>

Hello, I am trying to figure out how I can be able to find the average number of Calls per Hour? What I mean by this is I want to be able to see a line chart that on the x-axis shows 0 - 23 hour time bins and the y-axis shows average number of calls for each hour. This way I am able to see on average during any given day, how many calls I would average throughout each hour of the day. In my dataset I have a time-date field and a Call ID that I am using. I’ll provide some dummy data to illustrate.

 ![Dummy Call Data](https://d1wl4jav5dp96l.cloudfront.net/original/2X/0/0160eb57792014d9657596183cb4ea8757035ff1.png)

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [March 30, 2023, 10:02pm UTC](https://community.amazonquick.com/t/how-to-find-the-average-number-of-calls-per-hour/11708/2 "2023-03-30T22:02:08Z")

</div>

you can use extract function and then take avgOver

> **[truncDate - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/truncDate-function.html)**
>
> truncDate returns a date value that represents a specified portion of a date. For example, requesting the year portion of the value 2012-09-02T00:00:00.000Z returns 2012-01-01T00:00:00.000Z. Specifying a time-related period for a date that doesn't...

> **[avgOver - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/avgOver-function.html)**
>
> The avgOver function calculates the average of a measure partitioned by a list of dimensions.