How to Get Sum or Total of Distinct Value

[d4rlie891]

HI,

Anyone Can Help me, how to create a set Analysis for this case :

I want to create a set Analysis to get the Sum of Count Distinct Value ->112656.

I tried to create a set Analysis but result is 6,305.

Thanks

Dmw

[Anonymous]

Try using aggr

[Anil_Babu_Samineni]

Image showing Simple Distinct. But, KPI seems Total keyword(Don't required to get the same). Can you cross check/ Copy paste the expression. or else you may share sample to get it

[d4rlie891]

This is the expression : Count({$<MONTHYEAR = {"$(=max(MONTHYEAR))"}>} Distinct JOB_MEM_NAME).

I also attach the sample data

Thanks !

[vinieme12 · Accepted solution]

Your KPI object is showing correct distinct count, your table is showing you a sum of rows

if you want to match the same, try below

=sum(AGGR(  COUNT(....), DAY))

[Anil_Babu_Samineni]

What are the Dimensions here, Can you tell us MONTHYEAR. How you are taken this?

[d4rlie891]

ok thanks Vineeth. it works using this expression :

sum(AGGR(COUNT(Distinct {$<MONTHYEAR = {"$(=max(MONTHYEAR))"}>} JOB_MEM_NAME), DAY))