Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Highlighted
Mikasa
Level II

The Data Filter window is not interacting in HTML

Hi

I have made a Html report with my graphs, using HTML5 Auto report Add-In. But the filter window is not interactive. Is there any way to make it work and be selective?

Thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted

Re: The Data Filter window is not interacting in HTML

Hi @Mikasa

 

I learned from your earlier post: Create a HTML report for a script and outputs. that you are using JMP 14.

 

We built the Auto Report Add-in capability into JMP 14. So starting in JMP 14, you can access the same functionality from File > Publish. I mentioned some additional help resources in my reply to your previous post, but I'll repeat them here for anyone stumbling on to this post:

 

In JMP 14, Look for "Publish to File" in JMP Help. It in can be found under

Using JMP > Save and Share Data > Share Interactive JMP Reports on the Web.

 

See also:Sharing Interactive Web Reports in JMP® 14 ( US 2018 132 ) 

 

For JMP 15, see: Create a Web Report for information on publishing to a file, then scroll down to "Publish to JMP Public or JMP Live" if that interests you. 

 

If you are including a Data Filter rather than a Local Data Filter in your report, we don't support that yet, so it will not be interactive. If you are using a Local Data Filter, there a few things that would make it not work in Interactive HTML: 

  1. We can't support including or excluding rows in Interactive HTML since such a change requires the statistics engine of JMP itself which is not built in to the Interactive HTML capability. This can only be supported with JMP Live or JMP Public  since they communicate with JMP on a server. However, if you check "Show" and uncheck "Include" in the Local Data Filter                                         John_Powell_JMP_0-1581531438630.png                                                                                                                        before publishing or saving as Interactive HTML, you should see the graph controlled by it change as you interact with it. 
  2.   If you use File > Publish and unchecked "Publish Data", the graph will not be interactive since the report without data is just a little more than a picture of the report you exported.
  3. Some graphs in JMP do not respond to the "Show" capability of the Local Data Filter. If you see no reaction in JMP with the "Show" mode checked and the "Include" mode unchecked, you will not see any reaction when you change the Local Data Filter in the Interactive HTML version.
  4. Some graphs, or specific conditions applied to graphs may be filterable in JMP, but are not filterable in Interactive HTML. In this case, there should be a message explaining why in JMP's log when you publish or save as Interactive HTML. 
  5. If you are using an older browser, like Internet Explorer or an old version of Edge, the HTML Local Data Filter will not be interactive. 

If none of these explain why your Local Data Filter is not interactive, please provide more details about the report you are trying to publish. If you are uncomfortable sharing the details here, please contact JMP Technical Support. 

 

Thanks, 

~John

 

   

 

     

    View solution in original post

    Highlighted

    Re: The Data Filter window is not interacting in HTML

    When you have the Dashboard open, Interactive HTML is saved differently from Windows and Mac:

    • If you're running JMP on Windows, you can Find Save As in the File menu. If you select this, there will be an option to choose Interactive HTML and pick a location and file name.
    • If you're running  JMP on the Mac, you can use Export from the File menu.

    With the Dashboard's red triangle button, not the Local Data Filter's red triangle button, chose Save Script > To Script Window. You can copy this script into another script.

     

    The script command to save a report or dashboard as Interactive HTML is Save Interactive HTML(<path>) .

    You can see it in use in this discussion: save report as interactive html 

     

    As a new JMP user, you might find this blog useful:The 1st thing I wish someone had told me when I started using JMP: We are visual creatures 

    As a JMP User trying to learn JSL scripting, you may find this blog useful:

    The 1st thing I wish I knew when I started scripting: There are different kinds of scripts 

     

    Actually, both of these are a series of blogs with links to many resources that help.

     

    There are also many resources in the Help menu of JMP. The Scripting Index and the Scripting Guide under Help > Books is especially useful for scripting as is the Help > Scripting Index.

     

     

     

     

     

     

     

     

    View solution in original post

    7 REPLIES 7
    Highlighted

    Re: The Data Filter window is not interacting in HTML

    Hi @Mikasa

     

    I learned from your earlier post: Create a HTML report for a script and outputs. that you are using JMP 14.

     

    We built the Auto Report Add-in capability into JMP 14. So starting in JMP 14, you can access the same functionality from File > Publish. I mentioned some additional help resources in my reply to your previous post, but I'll repeat them here for anyone stumbling on to this post:

     

    In JMP 14, Look for "Publish to File" in JMP Help. It in can be found under

    Using JMP > Save and Share Data > Share Interactive JMP Reports on the Web.

     

    See also:Sharing Interactive Web Reports in JMP® 14 ( US 2018 132 ) 

     

    For JMP 15, see: Create a Web Report for information on publishing to a file, then scroll down to "Publish to JMP Public or JMP Live" if that interests you. 

     

    If you are including a Data Filter rather than a Local Data Filter in your report, we don't support that yet, so it will not be interactive. If you are using a Local Data Filter, there a few things that would make it not work in Interactive HTML: 

    1. We can't support including or excluding rows in Interactive HTML since such a change requires the statistics engine of JMP itself which is not built in to the Interactive HTML capability. This can only be supported with JMP Live or JMP Public  since they communicate with JMP on a server. However, if you check "Show" and uncheck "Include" in the Local Data Filter                                         John_Powell_JMP_0-1581531438630.png                                                                                                                        before publishing or saving as Interactive HTML, you should see the graph controlled by it change as you interact with it. 
    2.   If you use File > Publish and unchecked "Publish Data", the graph will not be interactive since the report without data is just a little more than a picture of the report you exported.
    3. Some graphs in JMP do not respond to the "Show" capability of the Local Data Filter. If you see no reaction in JMP with the "Show" mode checked and the "Include" mode unchecked, you will not see any reaction when you change the Local Data Filter in the Interactive HTML version.
    4. Some graphs, or specific conditions applied to graphs may be filterable in JMP, but are not filterable in Interactive HTML. In this case, there should be a message explaining why in JMP's log when you publish or save as Interactive HTML. 
    5. If you are using an older browser, like Internet Explorer or an old version of Edge, the HTML Local Data Filter will not be interactive. 

    If none of these explain why your Local Data Filter is not interactive, please provide more details about the report you are trying to publish. If you are uncomfortable sharing the details here, please contact JMP Technical Support. 

     

    Thanks, 

    ~John

     

       

     

       

      View solution in original post

      Highlighted
      Mikasa
      Level II

      Re: The Data Filter window is not interacting in HTML

      Thank you @John_Powell_JMP 

      Your response was very complete and detailed. 

      I could make the filter interactive with Local data filter but the problem is I have a lot of graphs and with the same Column to be filtered but only one local data filter can not be connected to all. I do not know any way to share one to all. Is there any way to do that?

       

      Thanks

      Highlighted

      Re: The Data Filter window is not interacting in HTML

      If you build a JMP Application or Dashboard, you can add the Local Data Filter at the top level.

       

      See this section of the Help to build a dashboard: 

      Using JMP > Extend JMP > Combine Reports by Creating a Dashboard > Example of Creating a Dashboard with Two Reports

      The same method can be used for more than two reports.

       

      To add the Local Data Filter to the dashboard,

      1. Click on the dashboard's top red triangle and select Edit.
      2. Then from the Sources panel drag in a Data Filter(Local) to the outermost box or the box just inside the Dashboard area. 
      3. Press the green triangle on the Dashboard Builder toolbar to run the Dashboard.
      4. Uncheck the Include mode of the Local Data Filter and test the Local data filter to make sure it affects two or more graphs in the dashboard. 

      Save as Interactive HTML. 

       

      ~John

       

       

       

      Highlighted
      Mikasa
      Level II

      Re: The Data Filter window is not interacting in HTML

      Thank you @John_Powell_JMP 

      I did all the same and I have the dashboard. I just could not find out how to save it as HTML.  Also, this report has  to get updated everyday. I tried to extract the Dashboard script and add to end of my own script but I could only add it as a new script in the data table. 

      I do not know how to make a one script that can make my data table and run the dashboard and save it in HTML.

       

      I am pretty new in JMP.  sorry if I am asking many questions.

       

      Thanks

      Highlighted

      Re: The Data Filter window is not interacting in HTML

      When you have the Dashboard open, Interactive HTML is saved differently from Windows and Mac:

      • If you're running JMP on Windows, you can Find Save As in the File menu. If you select this, there will be an option to choose Interactive HTML and pick a location and file name.
      • If you're running  JMP on the Mac, you can use Export from the File menu.

      With the Dashboard's red triangle button, not the Local Data Filter's red triangle button, chose Save Script > To Script Window. You can copy this script into another script.

       

      The script command to save a report or dashboard as Interactive HTML is Save Interactive HTML(<path>) .

      You can see it in use in this discussion: save report as interactive html 

       

      As a new JMP user, you might find this blog useful:The 1st thing I wish someone had told me when I started using JMP: We are visual creatures 

      As a JMP User trying to learn JSL scripting, you may find this blog useful:

      The 1st thing I wish I knew when I started scripting: There are different kinds of scripts 

       

      Actually, both of these are a series of blogs with links to many resources that help.

       

      There are also many resources in the Help menu of JMP. The Scripting Index and the Scripting Guide under Help > Books is especially useful for scripting as is the Help > Scripting Index.

       

       

       

       

       

       

       

       

      View solution in original post

      Highlighted
      Mikasa
      Level II

      Re: The Data Filter window is not interacting in HTML

      Thank you @John_Powell_JMP 

      I studied the material you mentioned and I leaned many a lot about JMP. And I could make a HTML and save it successfully.

      I tried to schedule the script to be run everyday and save the HTML since I have to insert the HTML link in a webpage for daily report.

      I am using ScriptHost Job manager, so I tried to make a WIJT-Script and the schedule it on Scripthost. 

      I get an error that is related to Dashboard builder script  as below:

      "

      The following objects failed to initialize and have been removed from the application. 

      Objects
      MainTabPage
      TabPage1
      TabPage2
      TabPage3"

       

       

      I have tried the script without Dashboard part and it works  perfectly but after adding that part, it can not be done.

      I searched to learn if there is any other way to automate script running every day is a certain time but no success.

      Would you please tell me if there is an alternative way?

      Thanks

       

       

      Highlighted

      Re: The Data Filter window is not interacting in HTML

      This paper/tutorial: Automated Report Creation: From Data Import to Publication ( 2019-EU-TUT-079 )  discusses using the  Windows Task Scheduler to automate publishing to JMP Public, but the same technique can be applied to saving a report or dashboard as Interactive HTML.  

       

      I hope you will also find the rest of the paper useful now, or in your future JMP automation efforts.

       

      ~John

      Article Labels