Average number of tickets per week

2 댓글

  • 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
  • Vladimir Petrushenka

    that did help, thanks very much RJ Hines

    0

댓글을 남기려면 로그인하세요.

Zendesk 제공