Show Discreet Values with Graph Builder Using Lines

[#1]

Hi,

I am working with a large data set, and I am using Graph Builder to display the results.  My problem is that if I use lines on Graph Builder to display the data, there is some smoothing taking place, and the shape of the line does not accurately represent the data.  If I use dots on Graph Builder, the data is accurate, but it is a little hard to see.  I can use the Overlay platform to achieve lines that accurately display the fine shape of the data, but the Overlay platform does not filter data as cleanly as in Graph Builder.

Does anyone have any suggestions about how I can use Graph Builder to accurately display the fine shape of the data?  I am using JMP11.

Thanks!

Names Default To Here( 1 );

dt = New Table( "Data",

      Add Rows( 1000000 ),

      New Column( "X", Numeric, Continuous, Format( "Best", 12 ), Formula( Row() ) ),

      New Column( "Y", Numeric, Continuous, Format( "Best", 12 ), Formula( Sequence( 1, 4, 1, 100 ) ) ),

      New Column( "Group", Numeric, Ordinal, Format( "Best", 12 ), Formula( Sequence( 1, 4, 1, 1 ) ) )

);

graphLines = dt << Graph Builder(

      Show Control Panel( 0 ),

      Variables( X( :X ), Y( :Y ), Group Y( :Group ) ),

      Elements( Line( X, Y, Legend( 7 ), Row order( 0 ), Summary Statistic( "Mean" ) ) ),

      Local Data Filter( Location( {0, 0} ), Add Filter( columns( :Group ) ), Mode( Select( 0 ), Show( 1 ), Include( 1 ) ) ),

      SendToReport(

            Dispatch( {}, "Graph Builder", OutlineBox, {Set Title( "Graph Builder with Lines" )} ),

            Dispatch( {}, "X", ScaleBox, {Min( 335000 ), Max( 338000 ), Inc( 200 ), Minor Ticks( 1 )} )

      )

);

graphDots = dt << Graph Builder(

      Show Control Panel( 0 ),

      Variables( X( :X ), Y( :Y ), Group Y( :Group ) ),

      Elements( Points( X, Y, Legend( 8 ), Jitter( 0 ) ) ),

      Local Data Filter( Location( {0, 0} ), Add Filter( columns( :Group ) ), Mode( Select( 0 ), Show( 1 ), Include( 1 ) ) ),

      SendToReport(

            Dispatch( {}, "Graph Builder", OutlineBox, {Set Title( "Graph Builder with Dots" )} ),

            Dispatch( {}, "X", ScaleBox, {Min( 335000 ), Max( 338000 ), Inc( 200 ), Minor Ticks( 1 )} ),

            Dispatch( {}, "400", LegendBox, {Position( {0} )} )

      )

);

overLines = dt << Overlay Plot(

      X( :X ),

      Y( :Y ),

      Grouping( :Group ),

      Connect Points( 1 ),

      Local Data Filter( Location( {0, 0} ), Add Filter( columns( :Group ) ), Mode( Select( 0 ), Show( 1 ), Include( 1 ) ) ),

      SendToReport( Dispatch( {}, "101", ScaleBox, {Min( 335000 ), Max( 338000 ), Inc( 200 ), Minor Ticks( 1 )} ) )

);

graphLines << Journal;

graphDots << Journal;

overLines << Journal;

[#2 · Accepted solution]

In JMP 12 the Graph Builder lines look "right" out of the box; it plots slower but without the automatic interpolation that happens in JMP 11 for large data sets.

If you reduce the number of rows (e.g. by truncating or summarizing) the stepwise line pattern will be correctly displayed in JMP 11 too. I tried to reduce the number of rows to 100000 and then it looked OK.

[#3]

Thanks MS.  Looks like I will have to deal with the problem until I can upgrade to JMP12.  Thank you for the input.