Average number of tickets per week


2 Commentaires

  • Hines, RJ

    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:


    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!

  • Vladimir Petrushenko

    that did help, thanks very much @...


Vous devez vous connecter pour laisser un commentaire.

Réalisé par Zendesk