Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I would like to ask a sort of a beginners question since i am rather new to this field.
I am looking to create a combo chart in order to represent the total tickets along with the ticket's average per week. Where i encounter the problem is calculating the average of the tickets. Using count(Week) basically displays the number of tickets on the specific Week and sum(Week) sums up the number of weeks e.g selecting weeks 5, 8 , 10, 12 it will add up 5+8+10+12, instead of 4 thus the average comes out wrong. What i'm expecting is if i select X random weeks the function should be the total amount of tickets on those X weeks divided by X
If you need any more information please let me know.
Would love to see your replies since the community has taught me a lot.
Thank you!
Do you have a field called Tickets? May be do this
Count(DISTINCT Ticket_ID)/Count(DISTINCT Week)
or
Avg(Aggr(Count(DISTINCT Ticket_ID), Week))
Do you have a field called Tickets? May be do this
Count(DISTINCT Ticket_ID)/Count(DISTINCT Week)
or
Avg(Aggr(Count(DISTINCT Ticket_ID), Week))
Thanks this works!
Appreciate your help