Script to highlight a cell in a report

altug_bayram — Fri, 22 Nov 2024 16:40:57 GMT

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

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

topic Script to highlight a cell in a report in Discussions

Script to highlight a cell in a report