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
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!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.