# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

## 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!

Tags (1)
1 Solution

Accepted Solutions
MVP

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

2 Replies
MVP

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

New Contributor

## Re: Beginner's question

Thanks this works!