Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
geoff1
Level II

HTML report different from JMP report

Hello,

I have an issue when I save my report as interactive HTML with JMP14.1

Attached are example with JMP 13 and JMP14.1

The html JMP13 looks like the original report.

But when I save as interactive html with JMP14.1, the charts look very different, I guess the local data filter is not applied, or html do not like the column Modeling Type like Ordinal ?

 

Could you have different filter per chart when we save as interective html ?

 

Any idea to fix it?

 

Thanks

Geof

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: HTML report different from JMP report

Here is one method

testsperday.PNG

Names Default To Here( 1 );
			
gb1 = Graph Builder(
	invisible,
	Size( 534, 464 ),
	Show Control Panel( 0 ),
	Variables( X( :EndTime ), Y( :ProcessedItem ) ),
	Elements( Bar( X, Y, Legend( 7 ), Summary Statistic( "Sum" ) ) ),
	Local Data Filter(
		invisible,
		Add Filter(
							
			columns( :DateTime ),
			Where( :DateTime > (Today() - In Days( 30 )) )
		),
		Mode( Select( 0 ), Show( 0 ), Include( 1 ) )
	), 
		
);

Report( gb1 )[Outline Box( 1 )] << set title( "Test per day" );
					
gb2 = Graph Builder(
	invisible,
	Size( 534, 464 ),
	Show Control Panel( 0 ),
	Variables( X( :Year ), X( :Week, Position( 1 ) ), Y( :ProcessedItem ) ),
	Elements( Bar( X( 1 ), X( 2 ), Y, Legend( 4 ), Bar Style( "Stacked" ), Summary Statistic( "Sum" ) ) ),
	Local Data Filter(
		invisible,
		Add Filter(
							
			columns( :DateTime ),
			Where( :DateTime > (Today() - In Days( 70 )) )
		),
		Mode( Select( 0 ), Show( 0 ), Include( 1 ) )
					
	)
);

Report( gb2 )[Outline Box( 1 )] << set title( "Test per Week" );

HTMLLreport2 = New Window( "Test Report", vlb = V List Box() );

vlb << append( Report( gb1 ) );
vlb << append( Report( gb2 ) );
Jim

View solution in original post

7 REPLIES 7
Highlighted
txnelson
Super User

Re: HTML report different from JMP report

It appears to be a JMP bug.  I would report it to JMP Support

     support@jmp.com

I have a work around, that just requires that you remove the Local Data Filter, and just leave the Where Clause.  It moves the Where Clause to the top of the output for the graph, but the graph is corrected

test report.PNG

HTMLLreport = New Window( "Test Report",
	V List Box(
		Outline Box( "Test per day", 
			
			Graph Builder(
				Size( 534, 464 ),
				Show Control Panel( 0 ),
				Variables( X( :EndTime ), Y( :ProcessedItem ) ),
				Elements(
					Bar( X, Y, Legend( 7 ), Summary Statistic( "Sum" ) )
				),
				Where( :DateTime > (Today() - In Days( 30 )) )
			)
		), 
			
			
		Outline Box( "Test per Week",
			Graph Builder(
				Size( 534, 464 ),
				Show Control Panel( 0 ),
				Variables(
					X( :Year ),
					X( :Week, Position( 1 ) ),
					Y( :ProcessedItem )
				),
				Elements(
					Bar(
						X( 1 ),
						X( 2 ),
						Y,
						Legend( 4 ),
						Bar Style( "Stacked" ),
						Summary Statistic( "Sum" )
					)
				),
				Where( :DateTime > (Today() - In Days( 70 )) )
			)
		)
	)
);
Jim
Highlighted
geoff1
Level II

Re: HTML report different from JMP report

Hi Jim,

Thanks for the work around , but we loose the html interactive feature. So I would have almost same resut if I just save as html.

I have more complicated reports mixing charts, distribution, different time frame... and the interactive features make the reports very usefull for deeper analysis.  I guess I will nedd to wait for JMP15 to save as interactive html.

 

Thanks a lot for you help

 

Geof

 

 

Highlighted

Re: HTML report different from JMP report

Thanks, Jim.  This is indeed buggy.  Part of the problem is the "invisible" attribute.  
Another part is the presence of two data filters in one window.  That feature is planned for JMP 15.

 

Geof, please remove the "invisible" attribute from the data filters, and split the graphs into separate windows.

 

Let me know if that doesn't work for you,

 

Heman.

Highlighted
geoff1
Level II

Re: HTML report different from JMP report

Hi Heman,

 

How to split the garphs into separate windows and save them into the same html report?

 

Thanks

geof

 

Highlighted
txnelson
Super User

Re: HTML report different from JMP report

Here is one method

testsperday.PNG

Names Default To Here( 1 );
			
gb1 = Graph Builder(
	invisible,
	Size( 534, 464 ),
	Show Control Panel( 0 ),
	Variables( X( :EndTime ), Y( :ProcessedItem ) ),
	Elements( Bar( X, Y, Legend( 7 ), Summary Statistic( "Sum" ) ) ),
	Local Data Filter(
		invisible,
		Add Filter(
							
			columns( :DateTime ),
			Where( :DateTime > (Today() - In Days( 30 )) )
		),
		Mode( Select( 0 ), Show( 0 ), Include( 1 ) )
	), 
		
);

Report( gb1 )[Outline Box( 1 )] << set title( "Test per day" );
					
gb2 = Graph Builder(
	invisible,
	Size( 534, 464 ),
	Show Control Panel( 0 ),
	Variables( X( :Year ), X( :Week, Position( 1 ) ), Y( :ProcessedItem ) ),
	Elements( Bar( X( 1 ), X( 2 ), Y, Legend( 4 ), Bar Style( "Stacked" ), Summary Statistic( "Sum" ) ) ),
	Local Data Filter(
		invisible,
		Add Filter(
							
			columns( :DateTime ),
			Where( :DateTime > (Today() - In Days( 70 )) )
		),
		Mode( Select( 0 ), Show( 0 ), Include( 1 ) )
					
	)
);

Report( gb2 )[Outline Box( 1 )] << set title( "Test per Week" );

HTMLLreport2 = New Window( "Test Report", vlb = V List Box() );

vlb << append( Report( gb1 ) );
vlb << append( Report( gb2 ) );
Jim

View solution in original post

Highlighted

Re: HTML report different from JMP report

Jim,

 

That works great.  Thanks so much for your help!

 

Heman.

Highlighted
geoff1
Level II

Re: HTML report different from JMP report

Thank you !

 

I will  test it with more complex report

 

Geof

Article Labels

    There are no labels assigned to this post.