Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to calculate the average of this calculatiion :
Thanks
as below
=AVG( AGGR( YourCountExpression , FieldToAggregateOn ) )
example average count by Country field
=AVG( AGGR( YourCountExpression , Country) )
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 :
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()
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.