Create multiple overlay plots and link the x-axes for zooming?

unknown

Hi,

I'm working at a solar energy company and we often need to browse and inspect time-series of meteorological and electrical power data (see example plot below).

It would be useful if I could have several overlay plots (e.g. one with irradiance over time, one with temperature over time, one with electrical power over time) on one page and have the x-axes (always time in this case) linked, so if I zoom into e.g. one hour in one overlay plot, the others are automatically zoomed to the same time window.

Here you can see how typical plots look like - I would like to establish the same plot within JMP.

Thanks for any hint!

Tobias

pmroz

Can be done in Graph Builder.  Your data needs to be "stacked", with one column for date (x axis), one column identifying the Y variable (e.g. wind velocity, ambient temperature, etc.), and one column with Y values.

Here's an example done in JSL, that starts with unstacked data, stacks it, and then plots it.

dt1 = New Table( "Unstacked", Add Rows( 5 ),

    New Column( "Date", Numeric, Continuous, Format( "m/d/y", 10 ),

        Input Format( "m/d/y" ),

        Set Values( [3502915200, 3505593600, 3508012800, 3510691200, 3513283200] ) ),

    New Column( "Wind", Numeric, Continuous, Format( "Best", 12 ),

        Set Values( [10, 20, 30, 20, 10] ) ),

    New Column( "Temperature", Numeric, Continuous, Format( "Best", 12 ),

        Set Values( [100, 20, 150, 175, 180] ) ),

    New Column( "Power", Numeric, Continuous, Format( "Best", 12 ),

        Set Values( [50, 51, 52, 53, 54] ) )

);

dt2 = Data Table( "Unstacked" ) << Stack(

    columns( :Wind, :Temperature, :Power ),

    Source Label Column( "Group" ),

    Stacked Data Column( "Y Values" ),

    Output Table( "Stacked" )

);

dt2 << Graph Builder(

    Show Control Panel( 0 ),

    Variables( X( :Date ), Y( :Y Values ), Group Y( :Group ), Color( :Group ) ),

    Elements(

        Line( X, Y, Legend( 3 ), Row order( 0 ), Summary Statistic( "Mean" ) )

    )

);