Former Member

# Use 3 different Measures in one piechart

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.

Pie Chart.png (12.0 kB)
10|10000 characters needed characters exceeded

### Related questions

Former Member
Posted on Nov 16, 2015 at 11:12 AM

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.

10|10000 characters needed characters exceeded
• Posted on Nov 04, 2015 at 09:22 AM

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

10|10000 characters needed characters exceeded
• Former Member
Posted on Nov 04, 2015 at 10:06 AM

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.

10|10000 characters needed characters exceeded
• Former Member
Posted on Nov 04, 2015 at 10:10 AM

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