nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Tracking a 96-well over time

FantaBola

Hello,

I have a kinetic assay that records OD over time on a 96 well plate.

The output is OD and I have data columns with time and location (A1, A2 etc) for each OD value.

By applying the map shape I can visualize the 96-well plate in Graph Builder on a certain time (e.g. at 0 or 1 hour).

Would it be possible for Graph Builder or another SAS JMP feature to show the development of OD over time on the same plate (similar to the Bubble Plot function) ?

Accepted answers

To expand on Ian's answer, you can add a local data filter to your graph, change your time axis to ordinal if you want to see discrete sample times, and then use animation under the data filter. If you run the script below you would just need to press play in the upper left:

Names default to here( 1 );

dt = Open( "$SAMPLE_DATA/Time Series/Air.jmp" );

Column( dt, "date" ) << Set Modeling Type( "Ordinal" );

graph = dt << Graph Builder(
	Size( 516, 680 ),
	Show Control Panel( 0 ),
	Variables( Y( :Ozone Concentration ) ),
	Elements( Bar( Y, Legend( 3 ) ) ),
	Local Data Filter(
		Add Filter(
			columns( :date ),
			Where( :date == 1953936000 ),
			Display( :date, Size( 256, 360 ), List Display )
		),
		Animation( Animate Column( :date ), Animate Rate( 90 ) )
	),
	SendToReport(
		Dispatch(
			{},
			"Ozone Concentration",
			ScaleBox,
			{Format( "Best", 9 ), Min( 0 ), Max( 10 ), Inc( 2 ), Minor Ticks( 1 )}
		)
	)
);

All comments

ian_jmp

Get your Graph Builder display the way you want it, then try adding your 'time' variable to the local data filter.

Names default to here( 1 );

dt = Open( "$SAMPLE_DATA/Time Series/Air.jmp" );

Column( dt, "date" ) << Set Modeling Type( "Ordinal" );

graph = dt << Graph Builder(
	Size( 516, 680 ),
	Show Control Panel( 0 ),
	Variables( Y( :Ozone Concentration ) ),
	Elements( Bar( Y, Legend( 3 ) ) ),
	Local Data Filter(
		Add Filter(
			columns( :date ),
			Where( :date == 1953936000 ),
			Display( :date, Size( 256, 360 ), List Display )
		),
		Animation( Animate Column( :date ), Animate Rate( 90 ) )
	),
	SendToReport(
		Dispatch(
			{},
			"Ozone Concentration",
			ScaleBox,
			{Format( "Best", 9 ), Min( 0 ), Max( 10 ), Inc( 2 ), Minor Ticks( 1 )}
		)
	)
);

Byron_JMP

JMP can do some fairly amazing things with this kind of data. (I'm not sure what you already know so some of this might be a little basic, who knows who else might read it.)

The first step it to get it in the right format. From an Excel mindset this is absolutely daunting, but the table tools in JMP make it easy. What we need is one column for time, one column for OD and one column for location. (also you might have replicates of a treatment on the plate, but that gets a little more complex, so I'm going to run with the simple case. If we had that, we might want to get the means of the treatment replicates, and in that case, we wouldn't have a location column, we would have a treatment column.)

-To get all the locations in one place, go to Tables>Stack, and stack all the columns that have OD data, and don't select any other column.

-This should result in one Time col, one col with OD values, and one col with Location IDs. (Rename the column with OD values "OD600" or something appropriate.

First graph: Use graph builder, put Time on the X axis and OD on the Y. Depending on what your're growing you see a roughtly sigmoidal shaped data point cloud. Last, add the Location variable to the overlay role. In the graph elements, turn on Data points and either the smoother or the connected line.

Bubble plot: X is time, Time is time, Y is OD, and ID is location. Run this graph, click the play button, and watch the most painful time series graph appear before your eyes, then never do this again or make any of you respected coworkers watch it. IMHO, the time variable should never be used for both the X axis variable and the Time role simultaneously. This is a graphical sin and an abomination (again, in my humble opinion, which might be strong.) If you had measured pH, O2, CO2, NH4, your favorite carbon source, Gln, Glu, or anyother metabolite, then looking at ratios of these on the X and Y axis and using the time variable in the time role is likely to be an interesting graph to look at. Bubble plots are great for looking at relationships between variables over time in groups and as individuals.

The real graph: Analyze>Specialized modeling>Fit Curve. Put Time in X, put DO in Y, and put Location in the ID/Group role. Go to the hot spot and try picking models that fit your data. (Sigmoidal>Logistic> try 4p and 5p options) The JMP fits all your growth curves and will give you a table of parameter estimates.

Hope this helps a little. This is usually some pretty fun data to work with, so if you end up making some killer figures, post an image if you can.

Cheers,

-B

Note: In JMP 14 there is a new tool that will do even more for this case, but I'm sure that will be covered when its available.

FantaBola

Thank you for your reply.

It was easy to re-write the script to my case and add my wells under Shape.

I have added the output below

96 well.PNG

I am glad that worked. How did you draw the circles in your shapes? They look nice!

FantaBola

I did not draw them. JMP have developed JMP-files with the 96-well and 384-well format. You can then add them under Map role in column properties.

Mark_Bailey

The shape files for the microtiter plate wells can be found in here in the JMP File Exchange area of the JMP Community.

ranjith94

Hi Mark,

I tried to make change 96 well plate design according to my plate design, which is 10*10 and 4 wells left empty in the middle. But my out put is showing empty graph. Is it possible to use this graph for producing heatmaps for multiple variables.