Pesquisas recentes

Sem pesquisas recentes

Average number of tickets per week

Respondido
image avatar

Vladimir P

Publicado 22 de mar. de 2021

Hi all, 

I've got an operational query which shows me the number of tickets created by date. The chart is a little bit all over the place(due to different volumes in different days) so it would be really useful to see what's the average number of tickets per 7 days/per calendar week. 

Does anyone have any idea how can I add that as a second axis/trend line to the chart(if it's possible at all)? 

Would be grateful for any advice on this. 

Many thanks

0

2

2 comentários

Data
    image avatar

    RJ Hines

    Hello Vladimir,

    Is this what you were looking for?

    I created this query using the Support:Tickets[Default] dataset, two metrics- COUNT(Tickets) and SUM(Tickets Created - Daily Average) and one custom Attribute: Week of Year (As Date). I wanted to have a better date display format for clarity (with a week starting on Mondays), and I used the following resource to help me:

    https://support.zendesk.com/hc/en-us/articles/360022372453-Explore-recipe-Creating-weekly-date-buckets

    For reference, my Week of Year(As Date) formula looks like this:

    "Week of" + " " + DATE_FORMAT(START_OF_WEEK_MONDAY([Ticket created - Date]),"MM/DD")

    Hope this helps!

    1

    image avatar

    Vladimir P

    that did help, thanks very much @...

    0

    Por favor, entrar para comentar.

    Não encontrou o que estava procurando?

    Nova publicação