cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-573198%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3EWhat%20determines%20the%20order%20of%20the%20platforms%20in%20a%20group-by%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-573198%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EI%20expected%20the%20value%20order%20of%20a%20column%20to%20define%20which%20value%20is%20shown%20first%20in%20analysis%20platforms%20when%20grouping%20by%20that%20column%2C%20but%20this%20does%20not%20seem%20to%20be%20the%20case%20(sex%3DF%20is%20always%20shown%20first%20in%20big%20class).%3C%2FP%3E%3CP%3EMy%20question%20is%20twofold%3A%3C%2FP%3E%3CP%3E1.%20can%20I%20affect%20which%20is%20shown%20first%3F%3C%2FP%3E%3CP%3E2.%20If%20not%2C%20how%20do%20I%20know%20which%20comes%20first%3F%20It%20does%20not%20appear%20to%20be%20alphabetical%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Edt%3DOpen(%22%24SAMPLE_DATA%5Cbig%20class.jmp%22)%3B%3CBR%20%2F%3EDistribution(%20Continuous%20Distribution(%20Column(%20%3Aheight%20)%20)%2C%20By(%20%3Asex%20)%20)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mvanderaa1_0-1669301522688.png%22%20style%3D%22width%3A%20360px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22mvanderaa1_0-1669301522688.png%22%20style%3D%22width%3A%20360px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22mvanderaa1_0-1669301522688.png%22%20style%3D%22width%3A%20360px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F47596iA7839A97E6E00F7E%2Fimage-dimensions%2F360x333%3Fv%3Dv2%22%20width%3D%22360%22%20height%3D%22333%22%20role%3D%22button%22%20title%3D%22mvanderaa1_0-1669301522688.png%22%20alt%3D%22mvanderaa1_0-1669301522688.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-573198%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3EData%20Blending%20and%20Cleanup%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuality%20and%20Process%20Engineering%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-573977%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20What%20determines%20the%20order%20of%20the%20platforms%20in%20a%20group-by%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-573977%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EYes%2C%20works%20with%20jmp%2016%20and%2017.%3CBR%20%2F%3Ehm%20...%22yesterday%22.%20I%20don't%20know%20...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-573969%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20What%20determines%20the%20order%20of%20the%20platforms%20in%20a%20group-by%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-573969%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EBut%20today%20it%20does%3F%20This%20was%20on%20JMP%2017%20but%20I%20think%20this%20has%20been%20working%20for%20a%20while.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-573570%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20What%20determines%20the%20order%20of%20the%20platforms%20in%20a%20group-by%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-573570%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EI%20could%20bet%20that%20yesterday%20it%20didn't%20work%20%3B)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-573552%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20What%20determines%20the%20order%20of%20the%20platforms%20in%20a%20group-by%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-573552%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pauldeen_0-1669385877442.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22pauldeen_0-1669385877442.png%22%20style%3D%22width%3A%20389px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22pauldeen_0-1669385877442.png%22%20style%3D%22width%3A%20389px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F47630i98A671F770F2E74B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22pauldeen_0-1669385877442.png%22%20alt%3D%22pauldeen_0-1669385877442.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pauldeen_1-1669385886616.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22pauldeen_1-1669385886616.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22pauldeen_1-1669385886616.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F47631iB3FA034FFD36E1E7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22pauldeen_1-1669385886616.png%22%20alt%3D%22pauldeen_1-1669385886616.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-573420%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20What%20determines%20the%20order%20of%20the%20platforms%20in%20a%20group-by%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-573420%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ENext%20question%20would%20be%3A%3CBR%20%2F%3Ehow%20chan%20I%20change%20...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-573259%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20What%20determines%20the%20order%20of%20the%20platforms%20in%20a%20group-by%20analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-573259%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHow%20come%20it%20doesn't%20seem%20to%20be%20alphabetical%3F%20Quickly%20tested%20by%20using%20with%20Big%20Class%20and%20using%20%3Aname%20as%20by%20column%20and%20to%20me%20it%20seems%20like%20it%20is%20in%20alphabetical%20order%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%0A%0Adt%20%3D%20Open(%22%24SAMPLE_DATA%5CBig%20Class.jmp%22)%3B%0A%0Adist%20%3D%20dt%20%26lt%3B%26lt%3B%20Distribution(%0A%20Continuous%20Distribution(Column(%3Aheight))%2C%20By(%3Aname)%2C%0A%20Histograms%20Only%0A)%3B%0A%0A%0Ashow((dist%20%26lt%3B%26lt%3B%20Xpath(%22%2F%2FOutlineBox%5Bcontains(text()%2C%20'Distributions%20name%3D')%5D%22))%20%26lt%3B%26lt%3B%20get%20title)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
mvanderaa1
Level IV

What determines the order of the platforms in a group-by analysis

I expected the value order of a column to define which value is shown first in analysis platforms when grouping by that column, but this does not seem to be the case (sex=F is always shown first in big class).

My question is twofold:

1. can I affect which is shown first?

2. If not, how do I know which comes first? It does not appear to be alphabetical

 

 

dt=Open("$SAMPLE_DATA\big class.jmp");
Distribution( Continuous Distribution( Column( :height ) ), By( :sex ) )

 

mvanderaa1_0-1669301522688.png

 

6 REPLIES 6
jthi
Super User

Re: What determines the order of the platforms in a group-by analysis

How come it doesn't seem to be alphabetical? Quickly tested by using with Big Class and using :name as by column and to me it seems like it is in alphabetical order

Names Default To Here(1);

dt = Open("$SAMPLE_DATA\Big Class.jmp");

dist = dt << Distribution(
	Continuous Distribution(Column(:height)), By(:name),
	Histograms Only
);


show((dist << Xpath("//OutlineBox[contains(text(), 'Distributions name=')]")) << get title);

 

-Jarmo
hogi
Level XIII

Re: What determines the order of the platforms in a group-by analysis

Next question would be:
how chan I change ...

pauldeen
Level VI

Re: What determines the order of the platforms in a group-by analysis

pauldeen_0-1669385877442.png

 

pauldeen_1-1669385886616.png

 

hogi
Level XIII

Re: What determines the order of the platforms in a group-by analysis

I could bet that yesterday it didn't work ;)

pauldeen
Level VI

Re: What determines the order of the platforms in a group-by analysis

But today it does? This was on JMP 17 but I think this has been working for a while.

hogi
Level XIII

Re: What determines the order of the platforms in a group-by analysis

Yes, works with jmp 16 and 17.
hm ..."yesterday". I don't know ...

Recommended Articles