Skip to Content

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

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply