2 Replies Latest reply: Aug 10, 2018 2:31 AM by Constantinos Charalambides

# Beginner's question

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

Would love to see your replies since the community has taught me a lot.

Thank you!

• ###### Re: Beginner's question

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))