In JMP 10 for Windows, the Line in Graph Builder would fit through every point (every row). I'm testing JMP 11 on Mac, and I get this result:
Is this a Mac thing, a JMP 11 thing, or am I missing a setting somewhere?
If you sort your X variable column and then replot you'll get a line through every point. If there are multiple Ys for a particular X the line will go through the mean value. You can also click the Row order checkbox for the line.
The Sort/Row Order fix works for the first part of the data, but not all of it. With the data sorted by occurred_at (the x variable), I get this when Row Order is unchecked:
The line does not fit through each point, instead smoothing them as I showed previously.
If I select "Row Order" on the same sorted data, I get this:
The line fits each point for part of the data on the left (the desired effect) , but then it just stops! Very mysterious indeed. I'll reproduce the graph in JMP 10 on Windows to show the difference if that helps.
I've noticed that with smaller datasets, the graphs perform the way I'd expect (i.e. more like the JMP10 on Windows). Is it possible that the line averaging is part of a data compression process used to display large data sets?
I typically graph between 100,000 and 1,000,000 rows. 3 days of 1 second resolution data for 3 objects is a common data set, for example.
I've been running JMP10 for the last few months due to the issue above, but I just installed JMP 11 to see if the update had fixed the issue. I have both 10 and 11 installed side by side, and you can clearly see the differences. This is the same file with the same scripts run in 10 (left) and 11 (right) with the Graph Builder (top) and Overlay Plot (bottom) compared. Only JMP11 Graph Builder shows this odd averaging behavior, and it appears to be a regression from JMP10's behavior.
Has anyone found a setting to fix this? I'd love to stick with JMP11 if I can find a solution.