Let's assume the value you are plotting is in a field [Value].
(1) Drag the [Value] field to the SIZE mark. Right click on the sum([Value]) shown in the marks area. Select edit in shelf. Change the formula to: Sum(ABS([Value])).
(2) Drag the [Value} field to the COLOR mark. Right click in the sum([Value]) shown in the marks area. Select edit in shelf. Change the formula to: Sum([Value]) / Sum(ABS([Value])).
(3) Select the COLORS mark box, select edit colors. Check the stepped colors box. Change to 2 steps. Click on the color box on the left, change to red, OK. Click on the color box to the right, select green, OK. Select OK.
Here is a quick intro on creating calculated fields - Create a Simple Calculated Field
Now to solve your issue, you need to create a calculated field with the following formula.
which will convert both positives and negative values to absolute values.This will solve your sizing problem.
To solve your coloring issue, you need another calculated field, that says,
If [Field] > 0 then 'Green' else 'Red' end
Use this field in color mark and assign the required colors over the default colors.
Hope this helps.
1 of 1 people found this helpful
Thank you this is exactly what I needed.