cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
robot
Level VI

Show Discreet Values with Graph Builder Using Lines

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!

9479_Untitled 3.jpg

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;

1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Show Discreet Values with Graph Builder Using Lines

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.

View solution in original post

2 REPLIES 2
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Show Discreet Values with Graph Builder Using Lines

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.

robot
Level VI

Re: Show Discreet Values with Graph Builder Using Lines

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