Use 3 different Measures in one piechart

[Former Member]

Hello,

I have 3 measures.

Measure 1 created from query 1.

Measure 2 &3 created from query 2.

Since webi allow only one measure, how can this be achieve? I have searched on google, but I did not found any comprehensible answers from other forum. I would appreciate if someone could help me with this.

[Former Member · Accepted solution]

I was unable to create a pie chart with 3 measures in Webi.

However in order to make my pie chart, I made a Calculation View in SAP Hana joining the measures from the 2 sources into one single measure.

I was then able to create my pie chart using one measure. Hence, created a variable with an IF statement to categories the pie chart.

[Former Member · Accepted solution]

Hi,

perhaps this can be useful

Regards,

Rogerio

[Former Member]

The diagram used in this post to illustrate the pie chart is from MS Excel.

[former_member220624]

Hi,

Please specify the exact requirement , then we can think of the apt If-Else statement.

Regards,

Amit

[Former Member]

Measure 1:

Measure 2:

Measure 3:

I need to create a pie chart using these 3 measures.

Therefore it should display as follows

Measure 1 = 4826.3/6053.25 * 100

Measure 2 = 1226.95/6053.25 * 100

Measure 3 = 0/6053.25 * 100

[Former Member]

That's what I was trying to do. I have created a Variable Measure Total.

Measure Total = Measure 1 + Measure 2 + Measure 3

Then created a Variable Dimension like:

If ___________ then "Measure 1"

ElseIf __________ then "Measure 2"

ElseIf ____________ then "Measure 3"

The problem is how do I differentiate them in the if condition statement.

[former_member220624]

Hi Ashraf,

Can you elaborate the requirement a bit more.

To start with you can try to include all the three measures in a variable and then using this variable.

Something of a If-else condition but then would like to know the requirement.

Hope this helps.

Regards,

Amit