cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • See how to use the JMP Marketplace – Free tools to expand JMP capabilities. Register. July 10, 2 pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
hogi
Level XIII

Graph Builder - Order by

changed behavior in JM19: 
https://community.jmp.com/t5/JMPer-Cable/New-in-Graph-Builder-for-JMP-19/bc-p/904473/highlight/true#... 


It's great that new functions are being added. But, JMP team, please (!!!) keep the old functionality as the default setting!
Otherwise, users will have to change hundreds of scripts!

 

We wondered about the new behavior: 
it always worked.  And "today" -- why are the main groups split into small chunks ?
hogi_0-1759079485333.png

@shannon-c-b , thanks for pointing to the root cause of the "bug":

 


As a workaround, one can create an auxiliary column to simulate the default (JMP ?-18) functionality of  order by () with JMP19:

hogi_0-1759078765052.png

 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
New Column( "myOrderBy",
	Formula( Col Mean( :height, :age ) * 10000000 + :height ),
) << run formuals();

Graph Builder(

	Variables(
		X( :age, Order By( :myOrderBy, Ascending, Order Statistic( "Mean" ) ) ),
		X(
			:age_name,
			Position( 1 ),
			Order By( :myOrderBy, Ascending, Order Statistic( "Mean" ) )
		),
		Y( :height )
	),
	Elements( Bar( X( 1 ), X( 2 ), Y ) )
);

 

2 REPLIES 2
hogi
Level XIII

Re: Graph Builder - Order by

Hi @shannon-c-b 
important: my workaround is not an exact 1:1 copy of the JMP18 style.
[TS-00240917]

my workaround:
- sorts the ages by mean(height)

- sorts the students by height within the age groups

JMP < v19:
- sorts the students by mean(height)  -> stores the order (*)
- sorts the ages by mean(height)
- places the students into the respective age groups - position by  (*)

 

as Robert shows up twice, Robert is positioned by mean(height) 
-> Please note the jumps around Robert #1 and Robert#2

hogi_0-1759341276018.png

my application case is for "students" with unique names, this is why I did not notice the difference.

If your dataset contains "students" with duplicate names and the above workaround is not suitable for you (i.e. if you require the specialty (*) ), please contact JMP Support (referencing TS-00240917). They will be able to provide a workaround.

hogi
Level XIII

Re: Graph Builder - Order by

subcategories sorted by order within the parent category?
-> here is the wish: options for "order by" in Graph Builder 

Recommended Articles