cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP 19 is here! See the new features at jmp.com/new.
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
Choose Language Hide Translation Bar
hogi
Level XII

Tall table - individual readouts on X and Y axis

How can I create a x / y plot using individual readouts / rows of a tall table.
e.g. cw1 data on X, cw20 data on Y.

Open( "$SAMPLE_DATA/Functional Data/Weekly Weather Data.jmp" );

 

hogi_0-1752657067715.png

minus 1 point for:
- creating a dummy table

- adding auxiliary columns to the main table

1 ACCEPTED SOLUTION

Accepted Solutions
hogi
Level XII

Re: Tall table - individual readouts on X and Y axis

I fear, some auxiliary columns are necessary to make it work.
But one can "store" them together with the report - as transform columns:

 

Open( "$SAMPLE_DATA/Functional Data/Weekly Weather Data.jmp" );
Graph Builder(
  Transform Column(
    "week20",
    Formula( Col Quantile( If( :Week of Year == 20, :TAVG, . ), 0.5, :STATION ) )
  ),
  Transform Column(
    "week1",
    Formula( Col Quantile( If( :Week of Year == 1, :TAVG, . ), 0.5, :STATION ) )
  ),
  Variables( X( :week1 ), Y( :week20 ) ),
  Elements( Points( X, Y, Legend( 3 ) ), Smoother( X, Y, Legend( 4 ) ) )
);

View solution in original post

1 REPLY 1
hogi
Level XII

Re: Tall table - individual readouts on X and Y axis

I fear, some auxiliary columns are necessary to make it work.
But one can "store" them together with the report - as transform columns:

 

Open( "$SAMPLE_DATA/Functional Data/Weekly Weather Data.jmp" );
Graph Builder(
  Transform Column(
    "week20",
    Formula( Col Quantile( If( :Week of Year == 20, :TAVG, . ), 0.5, :STATION ) )
  ),
  Transform Column(
    "week1",
    Formula( Col Quantile( If( :Week of Year == 1, :TAVG, . ), 0.5, :STATION ) )
  ),
  Variables( X( :week1 ), Y( :week20 ) ),
  Elements( Points( X, Y, Legend( 3 ) ), Smoother( X, Y, Legend( 4 ) ) )
);

Recommended Articles