cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
altug_bayram
Level IV

Script to highlight a cell in a report

hello everyone....

 

I am performing contingency reports across a number of categorical X's towards a given Y (categorical) - where I like to highlight contingency table cells (from output report) based on conditions : 

 

e.g. highlight if 

count >=12

Cell Chi Square >=3.0 

Would like to highlight the cell w/ some color (font color can also work, highlight is better) if it satisfies the given condition 

Additional request: Is there a way to either sort the rows based on eg. decreasing Cell Chi Square -- however as the rows contain multiple row elements (in my setup,  I use 3 : Count, Row % and Cell Chi Square) they would all need to be part of the sorting 

OR 

Is there a way to filter only rows that satisfy a given condition ? (ie these can be the highlighted ones) 

 

Here is a sample script targeting your sample data (Aircraft Incidents.jmp)
 
Contingency(
	Y(:Fatal),
	X(:Model),
	Contingency Table(
		Count(1, Format("Fixed Dec", 8, 0)),
		Total %(0, Format("Fixed Dec", 8, 2)),
		Col %(0, Format("Fixed Dec", 8, 2)),
		Row %(1, Format("Fixed Dec", 8, 2)),
		Expected(0, Format("Best", 8)),
		Deviation(0, Format("Best", 8)),
		Cell Chi Square(1, Format("Fixed Dec", 8, 4)),
		Col cumulative(0, Format("Fixed Dec", 8, 0)),
		Col cumulative %(0, Format("Fixed Dec", 8, 2)),
		Row cumulative(0, Format("Fixed Dec", 8, 0)),
		Row cumulative %(0, Format("Fixed Dec", 8, 2))
	)
);

 

thx 

Altug Bayram

 

0 REPLIES 0