Transforming integer to percentage in pie chart

[#1]

Hello everyone,

I am trying to convert number to percentage in a pie chart, which i have 3 expressions:

sum([Baby Boomers])

sum(X)

sum(Y)

In the Expression tab, when i select the relative box, all results are 100%:

If i unselect the relative box and set the percentage in the Number tab, the results are wrong:

Below is the chart with the original numbers:

How can i convert the numbers above to the correct percentage?

Regards

[Mark_Little]

Hi

I would look at something like

sum([Baby Boomers])  / (sum([Baby Boomers]) + sum(X) + sum(Y))

sum(X)  / (sum([Baby Boomers]) + sum(X) + sum(Y))

sum(Y)  / (sum([Baby Boomers]) + sum(X) + sum(Y))

Mark

[buzzy996]

can u share sample .qvw?

[#4]

Thanks for your response Mark.

I have other pie chart, with different expressions:

sum({<[Generations]={"Regional"}>}[Baby Boomers])

sum({<[Generations]={"Regional"}>}X)

sum({<[Generations]={"Regional"}>}Y)

I am just selecting values from Regional for each Generation.

How it should be the expression to calculate the percentage in that case?

Best regards,

[Marcio_Campestrini]

Rodrigo

You can calculate it or simply mark the option "Relative" in expressions tab.

[#6]

Hi Márcio,

When i select the option Relative in expressions tab, the result is wrong, all values is 100% as i mentioned before:

[settu_periasamy]

Hi Rodrigo,

May be try this expression..

sum({<[Generations]={"Regional"}>}[Baby Boomers])/sum({<[Generations]={"Regional"}>} TOTAL [Baby Boomers])

sum({<[Generations]={"Regional"}>}X)/sum({<[Generations]={"Regional"}>} TOTAL X)

sum({<[Generations]={"Regional"}>}Y)/sum({<[Generations]={"Regional"}>} TOTAL Y)

And, set the percentage in the Number tab..

[#8]

Hi settu_periasamy,

Unfortunately the expression you suggested didn´t work.

It displayed all values with 100%:

[swuehl]

Look at the alternative solution I suggested here:

Using multiple fields in a pie chart

i.e. use a dimension with one expression instead of three expression with no dimension. Then you can simply check the 'relative' option.

[settu_periasamy]

Hi Rodrigo,

Just to confirm,

Did you uncheck relative and set "Fixed to" and "Show in percentage" in Number Tab.

Or,

=Num(YourExpression,'#.##0%')   -> Expression Default in Number Tab