Skip to Content
Author's profile photo Former Member

How to combine several measures into 1 Pie chart

How to combine several measures into 1 Pie chart

Hi all,

Recently, I had a requirement to create a pie chart from several measures. As pie chart requires one measure, and multiple characteristics, this case is not trivial. In the following blog, I’m going to show you a simple way to create Pie graph from key figures.

My initial case is that I have several measures that I want to display on my pie graph:

/wp-content/uploads/2014/04/1_434919.png

In order to show them in pie graph, we need to convert them into characteristic, and create one key-figure to show the right measure for each characteristic.

In order to do that, we will use BEX capabilities, and create a structure that will have characteristic for each measure:

/wp-content/uploads/2014/04/2_434920.png

After that, we will create a formula that will display the right measure for each characteristic that we’ve created:

/wp-content/uploads/2014/04/3_434933.png

At that point we put “0” in the formula – we will fill the content later.

Now, what is left to do is use cells to fill the content of the measure we created:

/wp-content/uploads/2014/04/4_434934.png

In cells we put a reference on each relevant characteristic/measure (colored in blue) – to do that all you have to do is double click on the relevant cell.

/wp-content/uploads/2014/04/5_434935.png

And then, create a formula for each characteristic/measure (colored in red)

/wp-content/uploads/2014/04/6_434936.png

Each formula contain the relevant reference cell:

/wp-content/uploads/2014/04/7_434937.png

Now, what is left to do is hide the measures that we used, so that we see only one relevant measure:

/wp-content/uploads/2014/04/8_434938.png

That’s it. The query is now compatible with pie graph:

/wp-content/uploads/2014/04/9_434939.png

If we add it to Design Studio, it will work fine:

/wp-content/uploads/2014/04/10_434940.png

Good Luck!

Roman

Assigned tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo prabhith prabhakaran
      prabhith prabhakaran

      Interesting solution, Roman.

      Thanks for sharing..

      BR

      Prabhith

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Useful doc.  Thanks for sharing.

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice solution 🙂

      Thanks for sharing.

      Regards,

      Satendra Mishra

      Author's profile photo Koen Hesters
      Koen Hesters

      Great stuff, I will try to use for my webi's as well !

      Author's profile photo Former Member
      Former Member

      I have one more method. All is need, change the initial view and set filter on Structure.

      Author's profile photo Former Member
      Former Member

      Thanks Roman, this solved my headache! 🙂