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.
you can use extract function and then take avgOver