6 Replies Latest reply: Oct 8, 2013 7:30 AM by Gysbert Wassenaar

# Simple pie chart - can't get it to work.

Hi guys

I'm a relative noobie

I am trying to create a simple pie chart:

I have: Total

field1

field2

field3

field4

This is always true:

Total = field1+field2+field3+field4

In the pie chart I am creating I am using field1,2,3,4 as Dimensions (I want to group by them),

and sum(field1)/sum(Total), sum(field2)/sum(Total)... as the Expressions because I want to see their proportional size.

This is obviously wrong, as I am not getting the desired result

Any help?

• ###### Re: Simple pie chart - can't get it to work.

Hi, Leon.

If you remove the fields from the dimension and have each of the fields appear as expressions e.g.

sum(field1)

sum(field2) . . . .

Will that get what you are after ?

Regards,

Neil

• ###### Re: Simple pie chart - can't get it to work.

Indeed, if I leave the Dimensions it blank and move sum(field1), sum(field2).. to Expressions, I will get the desired numeric values.

However, if I choose "relative" in these fields, it yeids a pie chart with 100% for sum(field1), 100% for sum(field2)..

My question is how to get the correct relative info?

Another thing that is buging me is why do I need to leave the Dimensions blank? If I imagine my pie chart as a bar chart the Dimensions is the "group by" in the X-axis (I want a column for sum(field1), sum(field2)..) and the expressions is the Y value, which I want to be sum(field1)/Total, sum(field2)/total... I guess what I'm missing is to tie them up together somehow (Expression 1 to be on Dimension 1 column,Expr2 on Dim2 column ect..) Am I correct?

Thanks !

• ###### Re: Simple pie chart - can't get it to work.

Hi.

Try to move the field1, field2, field3 and field4 to the dimensions, and use the expression sum(amount), or whatever your amount field is called, and mark the Relative setting, and see what happens...

• ###### Re: Simple pie chart - can't get it to work.

I didn't figure this one out (Hans, your suggestion doesn't yeild the correct result, G Wassenaar, I can't open your file(no data))

Neil's answer was closeset, I will have to do with that.

Thank you all!