최근 검색
최근 검색 없음
Average number of tickets per week
답변함
2021년 3월 22일에 게시됨
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개
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 P
that did help, thanks very much @...
0