cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Reference visualization between different reports and datatables in JMP

I would like to have an interface which I could use to check different relations between different datatables and reports generated from them. This would help user to track how different data tables and visualisations might be related and possibly also help to visualise the flow needed to reach the end. Of course it would be nice to able to also something from this interface (bring table / table to top for example). This would require JMP to save the relations somewhere, so this should maybe be an option in Preferences.

 

Some example ideas (most likely there are way better visualizations for this):

Parallel plot:

jthi_0-1634722362035.png

 

Using ishikawa:

jthi_1-1634722377107.png

 

Obsidian notes - graph view graph view:

jthi_2-1634722447488.png

Folder structure:

jthi_3-1634723169182.png

 

Lazyu example script for parallel and ishikawa. Using something like this would work, but you would have to have your own functions/class to handle subsetting and so on, to get all references. You can also parse some names and link them back (subset and summary).

View more...
Names Default To Here(1);

demoList = New Table("datatablecollection", New Column("Parent", Character, Nominal), New Column("Child", Character, Nominal));

addToDemoList = Function({_parent, _child, dt = demoList},
	{Default Local},
	parentName = _parent << get name;
	childName = _child << get name;
	demoList << Add Row({Parent = parentName, Child = childName});
);

dt = Open("$SAMPLE_DATA/Big Class.jmp", invisible);
dt_subset = dt << Subset(all rows, invisible);
addToDemoList(dt, dt_subset);

dt_subset_subset = dt_subset << Subset(all rows, invisible);
addToDemoList(dt_subset, dt_subset_subset);

dt_subset_summary = dt_subset << Summary(Group(:name, :sex), Freq("None"), Weight("None"), invisible);
addToDemoList(dt_subset, dt_subset_summary);

dt_subset_subset_summary = dt_subset_subset << Summary(Group(:name, :sex), Freq("None"), Weight("None"), invisible);
addToDemoList(dt_subset_subset, dt_subset_subset_summary);

dt_summary = dt << Summary(Group(:name, :sex), Freq("None"), Weight("None"), invisible);
addToDemoList(dt, dt_summary);

obj = demoList << Diagram(Y(:Child), X(:Parent));

Close(dt, no save);
Close(dt_subset, no save);
Close(dt_subset_subset, no save);
Close(dt_summary, no save);
Close(dt_subset_summary, no save);
Close(dt_subset_subset_summary, no save);

_dt = New Table("Untitled 37",
	Add Rows(3),
	Compress File When Saved(1),
	New Column("Column 1", Character, "Nominal", Set Values({"Big Class", "Big Class", "Big Class"})),
	New Column("Column 2",
		Character,
		"Nominal",
		Set Values({"Subset of Big Class", "Big Class By (name, sex)", "Subset of Big Class"})
	),
	New Column("Column 3",
		Character,
		"Nominal",
		Set Values({"Subset of Subset of Big Class", "", "Subset of Big Class By (name, sex)"})
	),
	New Column("Column 4", Character, "Nominal", Set Values({"Subset of Subset of Big Class", "", ""}))
);

parallelPlot = _dt << Graph Builder(
	Size(495, 450),
	Show Control Panel(0),
	Variables(X(:Column 1), X(:Column 2, Position(1)), X(:Column 3, Position(1)), X(:Column 4, Position(1)), Color(:Column 1)),
	Elements(Parallel(X(1), X(2), X(3), X(4), Legend(3)))
);

 

3 Comments
hogi
Level XII

Cornerstone:

hogi_0-1720541079923.png

 

hogi
Level XII
Status changed to: Acknowledged