Avg count set anlysis

[eprehu]

How to calculate the average of this calculatiion : 

Thanks

[vinieme12]

as below

=AVG( AGGR(  YourCountExpression ,    FieldToAggregateOn ) )

example average count by Country field

=AVG( AGGR(  YourCountExpression ,    Country) )

[eprehu]

thanks but in the count expression, i am counting the number of client reachable and created in a selected period : 

If i want the avg, i have 1 as a result : 

[vinieme12]

Imagine a table with

Dimension = customer_key 

Measure = count(distinct customer_key)

The average of this will always be 1! that is what is happening right now

What average do you need exactly?

can you describe if you are trying to count " Avg Customers by ________ ? "

this ______  is the field you should be using for Aggr() 

[eprehu]

oh okay thanks, I want to average of customer CREATED AND CONTACTED by week of the month.

For the moment i want to customer created and contactable because i have no idea for the week month

Thanks.