Count Error

[pavansonu99]

Hi,

i have data like this

i am taking pie chart

QualificationCatagery as Dimension

and expression like this

=count(If(Aggr(NODISTINCT  Max(QualToDate), EmployeeNo) = QualToDate, EmployeeNo))

result is coming like this

this values are correct ...

when i select anything like one "Bachelor"

count is coming like this

please help me.

[sunny_talwar]

May be try this

=Count(DISTINCT Aggr(If(Max(TOTAL <EmployeeNo, QualificationCategory> QualToDate) = QualToDate, EmployeeNo), QualificationCategory, EmployeeNo, QualToDate))

[pavansonu99]

it is showing values like this. even before selection

[sunny_talwar]

Just showing 1 qualificationcategory?

[pavansonu99]

even full chart showing same result

[sunny_talwar]

and why do you think this number is not correct for Bachelor? Would you be able to share a sample of your app to check this out?

[pavansonu99]

for example i have 2 emp

emp1 have done bachelor and masters

and

emp2 done only bachelor

if i take pie chart baser on qualification

i will get  1 record under bachelor and i record under masters.

if i click on bachelor dimension in pie chart i will   get 2 values because both emp done bachelor 

.i want emp with highest qualification. evan i click on qualification dimension did you got it .

in the above chart 2925 is the value which have employees who have done bachelor and other higher qualifications i have to calculate emp highest degree according to QualDate

[sunny_talwar]

How about this then

=Count(DISTINCT Aggr(If(Max(TOTAL <EmployeeNo> QualToDate) = QualToDate, EmployeeNo), QualificationCategory, EmployeeNo, QualToDate))