Average age in a count expression

[bobbygino]

I want to calculate  an average age with a count distinct in an expression, need some help . thanks?

[agigliotti]

maybe this:

Avg( Aggr( Count(Distinct Age), your_dimension) )

[bobbygino]

Is not working ,  I have a list of persons with different ages

ID  Age

A=45

B=35

C=25

D=56

now I want to calculate the average age of my list

=avg(aggr(ID),AGE)) ???

[bobbygino]

=avg(aggr(count(ID),AGE)) ???

[Mark_Little]

Hi Marc,

I would Try something like the below

SUM(DISTINCT Age) / COUNT(DISTINCT Age)

Mark

[agigliotti]

maybe this:

Avg( Aggr( Count(Distinct AGE), ID) )

[manoj217]

this will shows the no of distinct values and finding the avg of that distinct values  not the ages

[agigliotti]

then simple use the below expression:

Sum(Age)

/

Count(ID)

[prithviram777]

Hi

try 

Avg(Aggr(sum( distinct (Age)),Age))

[martinpohl]

why do you want to use count in your expression?

avg (Agr) returns 40.24 (sum of 161 years devided by 4 ID)

Regards