Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
rverma
Level II

Changing bin size for Group X variable for each level in graph builder

I have created a chart in graph builder using jsl script below.

Data Table("Untitled 11967")<<Graph Builder(
		Automatic Recalc( 0 ),
		Variables( X( :var1 ), Y( :var2 ), Group X(:var3), Group Y(:var4)));

Here var3 is numeric continuous and var4 is numeric nominal. var4 just counts the number of times var3 value is occurring.

How can I change the number of levels for Group X variable in JSL? Also how can I set the binning for each level? Image below shows 3 levels which I set manually by right clicking on var3 and setting No of Level value to 3. But I want 3 levels 0-10, 10-15, 15-40 to group the counts in var4. How can I script it in JSL?

rverma_0-1581790564049.png

rverma_3-1581791328068.png

 

Any guidance will be highly appreciated.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Thierry_S
Level VI

Re: Changing bin size for Group X variable for each level in graph builder

Hi,
A possible work around would be to create a new ordinal character column with the specific bins you need with a formula (see below)

If(
	:Var3 <= 10, "0-10",
	10 < :Var3 <= 15, "11-15",
	15 < :Var3 <= 40, "16-40",
	"N/A"
)



Of note, you cannot have bin boundaries that overlap like suggested (i.e. 0-10 and 10-15)

Thierry R. Sornasse

View solution in original post

1 REPLY 1
Highlighted
Thierry_S
Level VI

Re: Changing bin size for Group X variable for each level in graph builder

Hi,
A possible work around would be to create a new ordinal character column with the specific bins you need with a formula (see below)

If(
	:Var3 <= 10, "0-10",
	10 < :Var3 <= 15, "11-15",
	15 < :Var3 <= 40, "16-40",
	"N/A"
)



Of note, you cannot have bin boundaries that overlap like suggested (i.e. 0-10 and 10-15)

Thierry R. Sornasse

View solution in original post

Article Labels

    There are no labels assigned to this post.