Skip to Content

Create pie chart using count / percentage function

Hi,

i have a larger raw-data table, from which I want to display a single measure in a pie chart. This measure is a kind of category and can have three values. I want to create a pie chart, which shows the summarized amount and/or percentage of all lines in this table.

How can I create this?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Mar 03, 2015 at 10:27 AM

    Hi Sascha - can you share screen shots of how you have tried this yourself and what/how is not working? Thank you

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Sascha,

      It looks like your data source is BW. After giving your requirement some further thought I think the only way to achieve the desired result is as follows:

      1. Create a BEx Query with the same structure as the Initial View in your screenshot. To this query you should add 3 formula columns, one for each possible value of Formel 1. The calculation in each of the 3 calculated columns should define the following boolean logic:

      1st Formula Column: Formel 1 = 1

      2nd Formula Column: Formel 1 = 2

      3rd Formula Column: Formel 1 = 3

      The above formula columns will act as counters, which will later be aggregated.

      2. Create an InfoCube with characteristics "Benutzer Sysubergr", "SAP Benutzertyp", "SAP System" and key figures Category 1 , Category 2, Category 3;

      3. Load the results of the query in Step 1 into the new InfoCube;

      4. Create another query over the new InfoCube, which has nothing in the row axis and only the three key figures in the column axis;

      5. The query in Step 4 should then be used as the Design Studio data source for the pie chart.

      To derive your required calculations at the right level of aggregation, I don't think it can be done without creating a new InfoCube and loading as described above. Perhaps others might have alternative ideas.

      Regards,

      Mustafa.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.