Bubble Plot showing proportionate data

tbps

Hi community, 

 

I have got the following problem and maybe someone can help out: I have a dataset which contains several tests (X4) and the according engine speed and power values. Now I would like to create a bubble plot showing the retention time for speed and power for each single test. The data should be binned for X2 in bins of 500 and X3 in bins of 10. This would then give me an overview of the exact portion in relation of the total testtime. 

First question: Is something like this possible? Second question: how do I do it?

 

Thanks for your help.

 

Testbed data.jmp

Byron_JMP

I couldn't help myself, this data set is just too tasty.

 

Add these two formulas to your table:

 

Batch Change Flag

If( Row() == 1,
	1,
	If( :Time == 0, 1, . )
)

Batch ID

If( Row() == 1,
	1,
	If( Is Missing( :Batch Change Flag ) == 1,
		Lag( :Batch ID, 1 ),
		Lag( :Batch ID, 1 ) + 1
	)
)

 

This will let you run this script

Bubble Plot(
	X( :X__3 ),
	Y( :X__2 ),
	Time( :Time ),
	Coloring( :X__6 ),
	ID( :Batch ID ),
	Speed( 220 ),
	Bubble Size( 10.89 ),
	Time Index( 30432 ),
	Color Theme( "Yellow to Blue" ),
	Color Levels(
		[-0.872 8.32714285714286 17.5262857142857 26.7254285714286 35.9245714285714
		45.1237142857143 54.3228571428571 63.522 72.7211428571429 81.9202857142857
		91.1194285714286 100.318571428571 109.517714285714 118.716857142857 127.916]
	),
	Title Position( -70.25, 3900 ),
	SendToReport(
		Dispatch(
			{},
			"1",
			ScaleBox,
			{Format( "Fixed Dec", 12, 0 ), Min( -100 ), Max( 75 ), Inc( 50 ),
			Minor Ticks( 1 )}
		),
		Dispatch(
			{},
			"2",
			ScaleBox,
			{Format( "Fixed Dec", 12, 0 ), Min( 500 ), Max( 4500 ), Inc( 500 ),
			Minor Ticks( 0 )}
		)
	)
)

Turn the speed up to 100%

Testbed data.jmp