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.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Attempting to find average numbers of calls made daily by individual agents | 12 | 952 | September 12, 2023 | |
| I have a field "time_range" which holds hours data at which row was created (like 0:00 - 0:59, 13:00 - 13:59 etc.) and I want to visualize the average of count of every time range. How can I do that? Also I want to order the time range by hour | 8 | 645 | April 12, 2023 | |
| Average Number of Logins for Weekday and time instead of Date | 1 | 114 | May 31, 2024 | |
| Calculate average of a measure over a specific period of time | 3 | 125 | November 2, 2025 | |
| Part Sum Part Avg Calculation problem | 2 | 21 | July 26, 2024 |