Accepted Solutions
Aah, thank you ask this example clarifies your use case! If I understand correctly, you want all of the individual track times plotted as separate points, not just a single point representing both of Tim's runs. I would approach this by making a column counting the number of times each person ran around the track so far, and then just plotting that against Calories Burned.
The formula for the times around track column could look like this (note how it just sums the number instead of having a column reference in the first argument):
Script to recreate chart:
Names default to here(1);
dt = New Table( "Count Table",
Add Rows( 11 ),
New Column( "Name", Character, "Nominal",
Set Values( {"Tim", "Tim", "Alex", "Alex", "Alex", "Alex", "Sara",
"Sara", "Sara", "Sara", "Sara"} ) ),
New Column( "Calories Burned", Numeric, "Continuous", Format( "Best", 12 ),
Set Values( [75, 155, 60, 130, 195, 240, 65, 125, 180, 235, 280] ) ),
New Column( "Times around Track", Numeric, "Continuous", Format( "Best", 12 ),
Formula( Col Cumulative Sum( 1, :Name ) ) )
);
g = dt << Graph Builder(
Size( 534, 456 ),
Show Control Panel( 0 ),
Variables( X( :Times around Track ), Y( :Calories Burned ), Overlay( :Name ) ),
Elements( Points( X, Y, Legend( 13 ) ), Smoother( X, Y, Legend( 15 ) ) )
);
Thank you for the warm welcome and I appreciate your time looking in to this! I plotted the variables on X and Y how I think it should be, and here is what I see:
This is almost correct, except for each X (ChipDieNum) there can be multiple Y values (ResDelta). Instead of plotting the X values, I want to plot the counts of each X (ChipDieNum) value.
As mentioned previously, X is set to Nominal and Y is Continuous.
Under Points, try changing the summary statistic to 'N':
I think this gives what you are looking for:
Script to recreate:
Names Default To Here( 1 );
dt = Open( "$Sample_data/big class.jmp" );
win = New Window("Example",
H List Box(
Graph Builder(
Size( 503, 256 ),
Show Control Panel( 0 ),
Variables( X( :age ), Y( :height ) ),
Elements( Points( X, Y, Legend( 3 ), Summary Statistic( "N" ) ) )
),
Tabulate(
Show Control Panel( 0 ),
Add Table( Row Table( Grouping Columns( :age ) ) )
)
)
);
I've tried doing that, but for some reason JMP is summarizing Y (I guess since it is continuous data) instead of summarizing N for X, so I end up getting a different graph:
While this is showing the counts of the ChipDieNumber, it's now plotting on the Y in place of ResDelta.
Aah, now I understand. You need to change your y axis to be ordinal or nominal data, and then choose the response axis to summarize under the red triangle for Points. In some cases you might need to bin the data first, for example by rounding to the nearest whole number, but in your case it looks like Res Delta is already a whole number.
Now for some reason the x axis labels messed up when I ran this, so I had to go into the x-axis settings and fix them. So, I thought this script should work:
Names Default To Here( 1 );
dt = Open( "$Sample_data/big class.jmp" );
dt:height << Set Modeling Type("Ordinal");
dt:age << Set Modeling Type("Ordinal");
Graph Builder(
Size( 502, 256 ),
Show Control Panel( 0 ),
Variables( X( :age ), Y( :height ) ),
Elements(
Points( X, Y, Legend( 3 ), Summary Statistic( "N" ), Response Axis( "X" ) )
)
);
but instead I needed to use this:
Names Default To Here( 1 );
dt = Open( "$Sample_data/big class.jmp" );
dt:height << Set Modeling Type("Ordinal");
dt:age << Set Modeling Type("Ordinal");
Graph Builder(
Size( 501, 256 ),
Show Control Panel( 0 ),
Variables( X( :age ), Y( :height ) ),
Elements(
Points( X, Y, Legend( 3 ), Summary Statistic( "N" ), Response Axis( "X" ) )
),
SendToReport(
Dispatch(
{},
"age",
ScaleBox,
{Label Row(
{Tick Mark( Label( "12" ), Label( "0" ) ),
Tick Mark( Label( "13" ), Label( "1" ) ),
Tick Mark( Label( "14" ), Label( "2" ) ),
Tick Mark( Label( "15" ), Label( "3" ) ),
Tick Mark( Label( "16" ), Label( "4" ) ),
Tick Mark( Label( "17" ), Label( "5" ) )}
)}
)
)
);
If this is the kind of graph you want
Here is the method that I used in JMP 11. Newer versions would make it easier.
First, I create a new column called "count" using the formula
If(Lag(:Die) != :Die | Row() == 1, x = 0); x++; x
The Label state is then applied to the Count column.
Each row has the Label State set for it. This will allow for the displaying of the value as a label.
ResDelta column is dragged to the Y dop area
Die is dragged to the X drop area
Count is dragged to the Color drop area
This last step is done so the color of the points can be changed to white, so they will not show on the graph. To change the color, just go to each of the colored points in the legend, right click on them one at a time, and change the color to white.
Here is an alternate method that I think will work in JMP 11 and will plot continuous values, and below that is perhaps an easier way to display this data using a histogram:
Method 1
Calculate the points to plot using tabulate with ordinal data types and a local data filter excluding missing values on what would be the x axis. Then in the new data table change data types back to continuous and plot.
- Add a new column with a formula like this (in newer versions of JMP you could do this right in the platform launch dialog without making a column):
- Open tabulate, change the y variable to nominal temporarily, you can change it back after this.
- Add a local data filter to exclude rows with missing ages, set to nominal, and select '0'
- Make into a data table
- Change data modeling types back to continuous
- Graph
Method 2
In graph builder make a histogram using only the y axis, and add a local data filter excluding missing values on what would be the x axis.
- Make the same 'is missing' column for the x axis variable
- Add that column as a local data filter in graph builder.
- Add the y variable to the y axis, it should be continuous
- Change the graph to a histogram
- Change the axis settings on the y axis to something reasonable. Note that this will still do some binning, so depending on your setting here it might combine heights 51.1 and 51.2 into the same bar with a count 2.
