Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
ConsumerType is a field with 4 values High, Medium, Low and Very Low.
I have to consider only 3 i.e High, Medium, Low and display their respective percentages.
Please help me out.
Thanks in advance!
I'll add that if you somehow want to lock the choices you do it by using Set analysis.
if you dont want to show Very Low, the expressions become
Count({$<ConsumerType-={'Very Low'}>} ConsumerID) / Count(total {$<ConsumerType-={'Very Low'}>} ConsumerID)
or if you like this syntax better:
Count({$<ConsumerType={'High','Medium','Low'}>} ConsumerID) / Count(total {$<ConsumerType={'High','Medium','Low'}>} ConsumerID)
If you have ConsumerType as Dimension
and have the expression as
sum(Value) / sum( Total Value)
or
count(ConsumerID) / count(Total ConsumerID)
Now you can pick the ConsumerType from a Listbox and the chart will show the percentages between the selected ConsumerTypes
HI,
You can write an calculated dimension as below.
=if(ConsumerType = 'Very Low',null(),ConsumerType )
Select "Supress When Value is Null"
Go to Expression and write your expression and click on "Relative"
Also click on "values on Data Point".
Go to "Numbers" tab and click on the expression and select "Show in %"
Regards,
Kaushik Solanki
Try a calculated dimension something like:
if(ConsumerType<>'Very Low',ConsumerType)
I'll add that if you somehow want to lock the choices you do it by using Set analysis.
if you dont want to show Very Low, the expressions become
Count({$<ConsumerType-={'Very Low'}>} ConsumerID) / Count(total {$<ConsumerType-={'Very Low'}>} ConsumerID)
or if you like this syntax better:
Count({$<ConsumerType={'High','Medium','Low'}>} ConsumerID) / Count(total {$<ConsumerType={'High','Medium','Low'}>} ConsumerID)