76035_en-US

liliconcom

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

Re: HTML report different from JMP report

Thank you !

 

I will  test it with more complex report

 

Geof

Re: HTML report different from JMP report

Jim,

 

That works great.  Thanks so much for your help!

 

Heman.

Re: HTML report different from JMP report

Here is one method

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 ) );

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

 

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

 

 

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.

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

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 )) )
   )
  )
 )
);