589793_en-US

liliconcom

Re: Graph Builder - subplot with different color settings?

Is there a reason to not use multiple graph builders (you are plotting two "different" things).

View more...

Re: Graph Builder - subplot with different color settings?

if you want to generate a dashboard - multiple Graph Builders are OK

- not very nice, but OK.

 

If you want to publish a paper or generate a final presentation for your management, everybody will definitely prefer the combined graph, not the screenshot of the Dashboard

Re: Graph Builder - subplot with different color settings?

Hm, as a fallback solution one could stack the 2 pieces of information into a single column to get the correct values for both plots.

 

But I hope that there exists a simpler solution directly via Graph Builder ?

 

 

 

 

 

View more...

 

Re: Graph Builder - subplot with different color settings?

Thanks to a question raised by @dale_lehman :
there is now also a new answer to this post

 

The result is not at all better than with the workaround - but it's now just a single step to get there   

 

 

dt = Open( "$SAMPLE_DATA/Airline Delays.jmp" );

dt << New Column( "ratio_week",
 Formula( Col Number( If( :Arrival Delay > 100, 1, . ), :Airline, :Day of Week ) / Col Number( 1, :Airline, :Day of Week ) )
);
dt << New Column( "ratio_month",
 Formula( Col Number( If( :Arrival Delay > 100, 1, . ), :Airline, :Day of Month ) / Col Number( 1, :Airline, :Day of Month ) )
);

Graph Builder(
 Size( 600, 557 ),
 Show Control Panel( 0 ),
 Summary Statistic( "Median" ),
 Graph Spacing( 4 ),
 Variables(
  X( :Airline ),
  Y( :Day of Month ),
  Y( :Day of Week ),
  Color( :ratio_month ),
  Color( :ratio_week )
 ),
 Elements( Position( 1, 1 ), Heatmap( X, Y, Color( 1 )) ),
 Elements( Position( 1, 2 ), Heatmap( X, Y, Color( 2 ) ) )
)

 

 

 

Graph Builder - subplot with different color settings?

Let's say I want to generate a graph to illustrate the ratio of flights with >100min delay, split by airline and separate graphs for the different days of a week and the days of the month.

 

As there is just a single "color" slot, I can just use the ratio per week OR the ratio per month as color - therefore, the other plot is always nonsense.

There are 2 legends which allow me to adjust the color ranges and gradient settings separately for both subplots, but I couldn't find the knob which allowed me to   select two different columns for the color of the two plots.

 

How can I create a plot in Graph Builder where both subplots show the correct values?

 

 

 

dt = Open( "$SAMPLE_DATA/Airline Delays.jmp" );

dt << New Column( "ratio_week",
 Formula( Col Number( If( :Arrival Delay > 100, 1, . ), :Airline, :Day of Week ) / Col Number( 1, :Airline, :Day of Week ) )
);
dt << New Column( "ratio_month",
 Formula( Col Number( If( :Arrival Delay > 100, 1, . ), :Airline, :Day of Month ) / Col Number( 1, :Airline, :Day of Month ) )
);

dt << Graph Builder(
 Size( 600, 557 ),
 Show Control Panel( 0 ),
 Summary Statistic( "Median" ),
 Graph Spacing( 4 ),
 Variables(
  X( :Airline ),
  Y( :Day of Month ),
  Y( :Day of Week ),
  Color( :ratio_month )
 ),
 Elements( Position( 1, 1 ), Heatmap( X, Y, Legend( 5 ) ) ),
 Elements( Position( 1, 2 ), Heatmap( X, Y, Legend( 6 ) ) ),
 Column Switcher(
  :ratio_month,
  {:ratio_week, :ratio_month},
  Retain Axis Settings( 1 )
 )
)

Mass Customization