topic Re: interactive HTML - file size? in Discussions

interactive HTML - file size?

hogi — Tue, 27 Jun 2023 19:43:11 GMT

I wanted to export a plot to an interactive HTML file.

The file was quite large, therefore I tried to reduce the size by generating the plot from a data view of the non-excluded rows.

Surprisingly, the file size was even bigger

The solution was:

Remove the link between data view and the original table (alternative: generate the subset without link :).

The behavior seems to depend on the plot type; for other plot types, the plot from the data view has a reduced file size compared to a plot from the original data table - but it's still quite big compared to a file that is generated with out a link.

Would it make sense that the html export is automatically generated for a temporary data set with cut link -
or alternatively: a warning could show up in the log telling the user that he could reduce the file size by cutting the link.

concerning "cutting the link" - I posted a wish to provide a single click solution to do so:

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


step1= dt0 << Concatenate(dt0, dt0, dt0, dt0, dt0, dt0, dt0, dt0);
dt = step1 << Concatenate(step1,step1,step1,step1);

SubsetLinked = dt << Select Where( :Airline == "Delta" ) << Data View;

SubsetWithoutLink = SubsetLinked<< Subset( All rows, Selected columns only( 0 ) );

gb1 = dt  << Graph Builder(
	Summary Statistic( "Median" ),
	Graph Spacing( 4 ),
	Variables( X( :Airline ), Y( :Arrival Delay ) ),
	Elements( Box Plot( X, Y, Legend( 4 ) ) )
);

gb2 = SubsetLinked  << Graph Builder(
	Summary Statistic( "Median" ),
	Graph Spacing( 4 ),
	Variables( X( :Airline ), Y( :Arrival Delay ) ),
	Elements( Box Plot( X, Y, Legend( 4 ) ) )
);

gb3 = SubsetWithoutLink  << Graph Builder(
	Summary Statistic( "Median" ),
	Graph Spacing( 4 ),
	Variables( X( :Airline ), Y( :Arrival Delay ) ),
	Elements( Box Plot( X, Y, Legend( 4 ) ) )
);

gb1 << Save Interactive HTML( "$TEMP/fullTable.html" );
gb2 << Save Interactive HTML( "$TEMP/linkedSubset.html" );
gb3 << Save Interactive HTML( "$TEMP/SubsetWithoutLink.html" );

Re: interactive HTML - file size?

John_Powell_JMP — Thu, 02 Feb 2023 14:47:03 GMT

Hi @hogi ,

Thank you for posting this question and the wish accompanying it.

Maintaining the link between a subset and its source table(s) requires storing relevant source table information and the links to that table. So, the additional information is expected.

In many cases, the link is not required for the report or dashboard you're exporting, but our export process does not have enough information to detect those situations. It would be best if that could be explicitly stated before exporting by cutting the link as you suggest. That way, any change in behavior caused by cutting the link in some cases can be experienced before exporting.

We can consider adding a warning in the log about the additional data requirements of linked data sets, but it will need to be written in a way that doesn't alarm users that do intend to maintain the linked behavior.

Thanks,

~John

Re: interactive HTML - file size?

hogi — Tue, 27 Jun 2023 19:42:18 GMT

Hi @John_Powell_JMP

Thank you for the explanation.

Is there a way to easily detect if a subset is linked or not?

Re: interactive HTML - file size?

Audrey_Shull — Mon, 03 Apr 2023 12:35:51 GMT

A JSL query to query a table about whether it is a linked subset did not previously exist. However, this conversation has caught the attention of JMP Development, and now a JSL message has been added in the next major release of JMP (JMP 18).

dt << Is Linked Subset; //will return 1 or 0

(I posted in the other thread linked to by @hogi as well.)