Wrong Percentage in stacked bar chart

[arixooo123]

I like to see the share of category A in category B, For example category A is Sex( Male,Female ) and Category B is opinion (good,bad).

i did the following :

I have added Sex and Opinion columns as Dimensions

in Expression Tab :

Expression One: 

1     

(Bar)

Expression Two:

COUNT(DISTINCT People)/Count(TOTAL <Sex> DISTINCT People)

(Values On Data Point)

The problem is the sum of each stack is more than 100% . what's the reason?

[#2]

Dear Arman,

Can you please add data table related to this query.

Thanks & Regards

Prince Anand

[arixooo123]

I can share some of the table...but is it because of the data or there is something wrong with my query?

How is it possible to have aggregate percentage more than 100%?  

[arixooo123]

here is the sample file

[jyothish8807]

Hi arman,

just reverse your expression.

make your denominator as numerator and vice versa.

Regards

KC

[arixooo123]

Thanks Buddy,

But i'm not sure i got what you said. Based on sample data i want to see the share of Remark Column (Active&Deactive) in the ValuableAtAll Column (Yes/No) . 

So i added ValuableAtAll and Remark As the dimension. then i

COUNT(DISTINCT SubID)/Count(TOTAL<ValuableAtall> DISTINCT SubID)

in the expression

[jyothish8807]

Hi arman,

try this:

Count(TOTAL<ValuableAtall> DISTINCT SubID)/COUNT(DISTINCT SubID)

Regards

KC

[arixooo123]

see what happened :

[jyothish8807]

Hi Arman,

try this,hope it works

in Dimension:

Valuableatall

exp1:

Count({<REMARK={'Active'}>} SUB_ID)/Count(SUB_ID)

exp2:

Count({<REMARK={'Deactive'}>} SUB_ID)/Count( SUB_ID)

Regards

KC

[jyothish8807 · Accepted solution]

Hi,

PFA.

Regards

KC