Average Calls by Hour - Last 7 Days

Respondida

4 Comentarios

  • Jessie Schutz
    Acciones de comentarios 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
    Acciones de comentarios 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
    Acciones de comentarios Permalink

    This worked perfectly - thank you!

    0
  • Nhia Lor
    Acciones de comentarios Permalink

    Awesome; glad to hear that did the trick!

    0

Iniciar sesión para dejar un comentario.

Tecnología de Zendesk