취소
다음에 대한 결과 표시 
표시  만  | 다음에 대한 검색 
다음을 의미합니까? 

Discussions

Solve problems, and share tips and tricks with other JMP users.
언어 선택 변환 막대 숨기기
hogi
Level XIII

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 채택된 솔루션

채택된 솔루션
hogi
Level XIII

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

원본 게시물의 솔루션 보기

1 응답 1
hogi
Level XIII

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

추천 글