How to show percentage of Count?

[#1]

Hi,

I have dimension Week  as =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek) and expression Count as Count(DISTINCT {$<Chore={'Soaps'},Flag={2}>}ID)

it is working in Bar chart. But I need to show another expression as % of Count as another expression. I used below one but it is not working and showing error in expression.

Count(DISTINCT {$<Chore={'Soaps'},Flag={2}>} ID,'#,##0.00%')

Can anyone help me how to write correct expression to show percentage of count.

Thanks.

[alexandros17]

Try

Count(DISTINCT {$<Chore={'Soaps'},Flag={2}>} ID,'#,##0.00%')

/

Count(TOTAL {$<Chore={'Soaps'},Flag={2}>} ID,'#,##0.00%')

[#3]

Thanks. Again it is showing error in expression. Any change in expression?

[SunilChauhan]

Count(DISTINCT {$<Chore={'Soaps'},Flag={2}>} ID)/Count(all {$<Chore={'Soaps'},Flag={2}>} ID)

chart properties-> number ->fixed to 2

hope this help

[#5]

will this work? as I tried this

Count(DISTINCT {$<Chore={'Soaps'},Flag={2}>} ID)

/

NUM(Count(TOTAL {$<Chore={'Soaps'},Flag={2}>} ID),'#,##0.00%')

[alexandros17 · Accepted solution]

Sorry, I forgot distinct:

Num(

Count(DISTINCT {$<Chore={'Soaps'},Flag={2}>} ID)

/

Count(TOTAL DISTINCT {$<Chore={'Soaps'},Flag={2}>} D)

,'#,##0.00%')

[#7]

Thanks.I used this. I have one doubt here.  If the count is 10. The percentage of count is showing 34% . Is that correct?

[alexandros17]

It depends on your data,

what we have done is divide count of your field by count of all the values, is this correct?

To understand better, use a chart with the same dimension and split the expression in two expressions,

one for the numerator and one for the denumerator, if data are correct, it is all ok

[#9]

Thanks. I need to show as only one expression. Is it possible?

[alexandros17]

Sure it is possible, but the purpose of the two expression is only to verify data.

The unique expression is numerator / denumerator