Skip to Content
avatar image
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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2015 at 10:10 AM

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

    Add comment
    10|10000 characters needed characters exceeded