Tall table - individual readouts on X and Y axis

hogi — Wed, 16 Jul 2025 09:41:19 GMT

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" );

minus 1 point for:
- creating a dummy table

- adding auxiliary columns to the main table

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

hogi — Wed, 16 Jul 2025 13:45:28 GMT

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 ) ) )
);

topic Tall table - individual readouts on X and Y axis in Discussions

Tall table - individual readouts on X and Y axis

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