Bubble Chart function - change absolut numbers into % of total

Question

Hi fellows,

This little problem haunts me.

For my bubble chart I have two numeric variables for the X and Y axes, which is in absolut numbers.

I want the x and y axes of the chart to display as % of total - how to do this?.

My chart is meant to display the changing relative size of different organizational units over a period of 20 years.

I hope it is possible through the bubble chart graph-function, rather than computing the data into proportions.

And · Answer

Thanks a million, it was basicly that "by" in the 'sum col' custom transform I did need.

danschikore · Answer

If I understand correctly, I think Ian's example is very close to what you want.  In order to get percentages by year (or whatever the time unit is) you can use a By variable in the Col Sum() formula.  Here is an example looking at relative changes in SAT scores between US regions:

Open("$SAMPLE_DATA/SATByYear.jmp");
Bubble Plot(
	X(
		Transform Column(
			"SAT Math Percentage",
			Formula( :SAT Math / Col Sum( :SAT Math, :Year ) )
		)
	),
	Y( :Name( "Expenditure (1997)" ) ),
	Time( :Year ),
	ID( :Region ),
	Time Index( 3.9 ),
	Title Position( 0.01978, 7.4 )
);

To create the Transform Column interactively, right-click on the column that you want to change during the launch, and choose "Formula":

In the formula dialog you can define the formula to convert from to relative values by year:

This approach works in any JMP platform and for any transformation that can be defined using JSL expressions.

And · Answer

Thank you for your reply and your time.
It is not quite what i want.

I basicully want to know, if the "Bubble chart" function, is able to do the % of total.