I am using Bo 3.1 sp3… I am having an issue building a pie chart.
Say I have EMP, Sal, Sal Total. I need to show pie of only one employee at a time. Now for employee A I need to show pie chart as what is the Sal of the total. So the data looks like this
Empname Sal SalTotal
-----------------------------------
A 500 2000
--------------------------------
I know you can not show 2 measures on pie chart…
But still… is there a way… or may be instead of Pie, use some other chart which works best in this case.
Pie charts are limited to one measure because the values have to add up to 100%. With multiple measures there’s no way to ensure that, thus you can’t use more than one measure in a pie.
But, you might wanna try this solution as it worked for me.
Before you create a chart, think about the story you want to tell. Then consider creating a bar chart over a pie. Pie charts do not really (effectively) tell the story. (In my opinion) I have certainly recently shifted my paradigm.
An interesting article about our facination with all things circular:
Here is another good presentation on dashboard design. I found it to be very helpful
Here is what SAP says about Pie charts:
“Do not Use it…
For exact comparisons of values, because estimating angles is difficult for people.
For rank data: Use column/bar charts in this case; use multiple column/bar charts for grouped data
If proportions vary greatly; do not use multiple pies to compare corresponding parts.”
Thanks for the reply. even i am not a big fan of Pie charts. but the user wants it… since there are only 2 measurs and one Row… the user whats to see Total value and what is the slice for Sal in that…
Bar charts with just 2 bars does not look good.
(BOB member since 2012-12-19)