topic Re: Extract table variable in graph builder in Discussions

Extract table variable in graph builder

SophieCuvillier — Thu, 08 Jun 2023 16:36:34 GMT

Hello,

I have a JMP table with multiple table variables. For instance, this table is the result of a data extraction between my start time "January 2023" and my end time "March 2023". I saved as table variables this start and time. I would like from this table to go on Graph builder and find somewhere the information about my table variables and add it as hover for instance. I know this is possible by jsl, but is it possible by just click-buttons on Graph builder ?

JMP Version: 16.0

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Boston Housing.jmp" );
dt << New Table Variable( "Start time", "January 2023");
dt << New Table Variable( "End time", "March 2023");
names = dt << Get Table Variable Names;
Show( names );

Thanks in advance

Re: Extract table variable in graph builder

ih — Wed, 15 Feb 2023 15:20:23 GMT

You can access table variables just like columns, so in the hover label editor you can just reference that variable.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Boston Housing.jmp" );
dt << New Table Variable( "Start time", "January 2023");
dt << New Table Variable( "End time", "March 2023");

In the hover label editor:

Try adding a textlet with with in the HTML Markup:

The start time is '{:Start time}'

That would show the table variable's value when hovering over a point:

Re: Extract table variable in graph builder

SophieCuvillier — Mon, 27 Feb 2023 15:32:26 GMT

Thank your for your answer, this is exactly what I looked for !

Re: Extract table variable in graph builder

JamieGlenn — Tue, 21 Mar 2023 08:09:30 GMT

Thanks for the answer.