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

Former Member
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
• Former Member
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
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
Nov 04, 2015 at 10:10 AM

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

10|10000 characters needed characters exceeded
• Former Member 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

Measure 1.png (9.3 kB)
Measure 2.png (11.2 kB)
Measure 3.png (10.9 kB)
Untitled.png (6.3 kB)