Average Calls by Hour - Last 7 Days

Answered

4 Comments

  • Jessie Schutz
    Comment actions Permalink

    Hi Therese!

    I'm not sure whether it's possible to do that or not...I'm going to see if I can find someone who knows the answer for you! Stand by!

    0
  • Nhia Lor
    Comment actions Permalink

    Hi Therese,

    This should be possible through creating a custom metric to calculation the average calls per hour over the last 7 days.  A simple custom metric like this example should do the trick if you wanted to give it a crack.

    SELECT # inbound Calls / 7

    We're dividing the results by 7 because we want to see the average over the last 7 days once we slice the results by the hour of the day.

    When constructing the report to use this metric and slice the metric above by the attribute "Hour of Event".  As long as you also add a report filter to filter the results based on the last 7 days "Date (Event) is the last 7 days" it should be giving you the average inbound calls per hour over the last 7 days.

    Hopefully this helps you further along with this one!

    1
  • Therese Stevens
    Comment actions Permalink

    This worked perfectly - thank you!

    0
  • Nhia Lor
    Comment actions Permalink

    Awesome; glad to hear that did the trick!

    0

Please sign in to leave a comment.

Powered by Zendesk