We’re asking you to select a content label when starting a new topic in the Discussions area. Read more to find out why.
Choose Language Hide Translation Bar
Highlighted
julian
Staff

Re: An updated question about slope graphs/parallel plots with multiple response data

This is very strange indeed! Are you using a Mac or Windows machine? Perhaps there is some difference in how that forced blank is rendered. 

Highlighted
caseylott
Level III

Re: An updated question about slope graphs/parallel plots with multiple response data

I agree this is strange. It’s a windows machine. I haven’t been able to figure out an alternative to the escape character so for now I’m just living with the odd boxes inside my graph. If anyone has a suggestion about this, I’d be grateful. I’m going to use this graph type for an upcoming presentation and I think this looks sloppy. Also, if anyone knows how to control the font size for category labels that would be awesome. Without being able to make this smaller, some of the labels aren’t being rendered.

Thanks to anyone who can help.
Highlighted
julian
Staff

Re: An updated question about slope graphs/parallel plots with multiple response data

Interesting, this must be a mac and windows difference in how that character is rendered. Here's something to try: edit the formula for that column. It will appear as though there is no special characters, but double click in the formula to edit the jsl. There will appear to be a special character in there. Here's how it looks on my mac:

Screen Shot 2020-03-02 at 11.04.01 AM.png

 

Delete that character and replace it with the escape character blank

 

Screen Shot 2020-03-02 at 11.05.13 AM.png

 

Close the formula and try the plot again. I'm thinking that windows and mac resolve that special space in their own way, and aren't functionally equivalent cross platform. 

 

As for changing the size, the easiest way in this case is to scale all fonts using the view menu > decrease font size.

Highlighted
caseylott
Level III

Re: An updated question about slope graphs/parallel plots with multiple response data

Hello again. With the help of @julian I've been able to accomplish most of what I'd like with this graph (see below). I still haven't been able to figure out how to get the escape character to STOP showing up in the graph. I tried the suggestion of replacing it with a blank space, but this just removed all of the category labels. Bummer.

 

caseylott_0-1583170940698.png

 

There are two more things I noticed as I worked on this graph that I'll probably add to the wish list for this graph type... If I'm missing something here and what I am suggesting really can be done, please let me know how, and I won't put it on the suggestion list...


First, I couldn't find any way to control line width. I think this graph would be easier to read if the lines were thinner than what I ended up with. The graph> marker size controls didn't work for this and I couldn't think of any other way to do this. It would be nice if there was a "line size" slider for this type of graph located right next to the "line curve" slider.

 

Second. I had pre-determined sort orders that I wanted to apply, independently, to both x variables. Because the "sort" drop zone in graph builder only seems to work for the left x variable in this graph type I had to use value ordering, which took a while, to achieve the desired sort order. If there was a way to use one column value to sort the left x variable and another column value to sort the right x variable, this would have saved some time and been less prone to the type of manual sort errors that can creep in with long lists when using value ordering. The built in arrows to reverse the sort order for both the left and right x variables suggests that they can be sorted independently. I just couldn't figure out how to use column variables to do this.

 

I've attached the JMP table, with the graph script save to it, in case anyone with a windows machine wants to see if they can replicate the escape character problem or look for solutions to the other issues raised here. As usual, this community is really fantastic when it comes to figuring things out like this. Thank you, all.

Highlighted
julian
Staff

Re: An updated question about slope graphs/parallel plots with multiple response data

Hi @caseylott,

In your table it looks like the escape character isn't entered correctly -- 

 

Screen Shot 2020-03-02 at 12.52.29 PM.png

But, perhaps that was intentional as a holding space as you try other things? It's strange that adding the special space to the text would result in it being entirely blank. When you typed in the jsl in the formula editor jsl window, was it exactly this? 

:CalVegName || "                                                      \!b"

As for changing the line width, normally with a parallel plot this is controlled by right clicking the graph > Customize, then change the settings for the Parallel Plot item. This does not appear to work in this case because with only categorical variables jmp is combining the sets and sizing automatically to fill the available space. Accordingly, you could affect the relative sizing of the lines to text by expanding or contracting the window, and then changing the font size. 

 

Finally, the ordering of categorical columns is always controlled datatable-wide with the column property of Value Ordering. Right click in the data table whichever column you wish to set ordering for, go to column properties, then value order. There you can set the custom order, or allow the ordering to be sorted naturally (via an alpha sort). 

 

Screen Shot 2020-03-02 at 1.01.53 PM.png

I hope this helps get you closer!

 

Highlighted
caseylott
Level III

Re: An updated question about slope graphs/parallel plots with multiple response data

Hi Julian,
You were right. The text in my formula editor was something I was trying out. When it looks exactly as you specified, I get the empty rectangle in the graph instead of the characters. See below. Either way, I can't seem to get an absence of characters to show up. Every time I type in \!b and apply the change in formula editor, this ends up being replaced by the following when I open the formula editor...
:CalVegName || "                                                      "

When I double click to edit this, I see the following...
:CalVegName || "                                                      BS"


Highlighted
julian
Staff

Re: An updated question about slope graphs/parallel plots with multiple response data

Interestingly, that's the exact behavior I have on my mac (the blank and then when double clicked, the BS in the place of the blank space escape), and yet when plotted there is no rectangle.
Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: Is it possible to create a many-to-many slope graph in JMP?

Sure, another name for this is a Parallel Plot. Graph Builder makes these already.

 

Drag Character and Group to the X axis and then click the Parallel Plot element JMPScreenSnapz007.pngabove the graph.

 

SlopeGraph.gif

 

Attached is a sample data table with a script to create this graph.Sorry I couldn't get the actual data for superheroes and teams.

 

-Jeff
Highlighted
lala
Level III

Re: Is it possible to create a many-to-many slope graph in JMP?

That's a good idea.