Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Hey Neil, thanks for your reply.
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 !
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...
See attached example. Perhaps you need to transform your source data like I did for the bottom pie chart.
Thanks for your reply guys.
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!
Try downloading it again. I downloaded it again and it works fine here.