Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- JMP User Community
- :
- Discussions
- :
- HTML report different from JMP report

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Sep 27, 2018 1:23 AM
(7866 views)

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

Jim

7 REPLIES 7

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

Jim

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

Jim

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: HTML report different from JMP report

Jim,

That works great. Thanks so much for your help!

Heman.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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.