This is the JMP Live 17.0 help. Other versions include 16.2, 16.1, 16.0 and 15.2.

JMP Live Help
Create visualizations with your data in JMP and share your analyses or data as posts in JMP Live. Anyone viewing these posts has the interactive capabilities of JMP to explore your data.
Find out more about these JMP Live topics:
Publish JMP Content
Create your reports in JMP and publish them as posts in a JMP Live space. You can also publish data as a JMP Live post. Space access determines how people can interact with your posts.
For details about how to publish content from JMP, see Share Reports to JMP Live in the JMP Help.
About JMP Live
In JMP Live, all posts and folders are contained in a space.
Report posts contain a JMP Live report (which can contain data) and data posts contain a JMP Live data table.
You can open posts or folders from any of these locations:
Home contains all posts in spaces that you have permission to access.
Featured contains any posts that are featured by a JMP Live administrator.
Spaces contains the spaces that you have access to and all discoverable spaces.
Figure 1.1 Report Post in a Space and Folder (Card Format)
Report Post in a Space and Folder (Card Format)
Note: Report posts appear in a post summary that is formatted as a card or a list. See Change the Format of Posts.
On the post summary, you see details such as the title, folder name (if applicable), time of last update, space the post is in, the user who published the post, how many views or comments the post has, and more.
To see details about a post:
From a post, click Details Image shown here.
From a post summary, click More Image shown here > Details.
JMP Live Spaces
In JMP Live, all posts and folders are contained in a space:
When you first log in to JMP Live, a personal space is created for you which you can publish to. In your personal space, you can also edit, replace, or delete your posts.
The posts and folders that you see depend on which spaces you have access to individually or through or group membership (controlled by JMP Live administrators).
Spaces are created by JMP Live administrators or users with admin permission on all spaces in JMP Live.
What you can do in a space depends on the permissions you have in the space. See Types of Space Permissions.
Permissions to spaces are controlled by a JMP Live administrator or JMP Live users who have administrative access to a space. See Update Users or Permissions in a Space.
Find out what you can do in JMP Live spaces:
Update Users or Permissions in a Space
In your personal space, you can update users or permissions. In other spaces, only JMP Live admins or users who have administrative access can update users or permissions.
To access permissions, in a space, click Permissions Image shown here:
Tip: If you do not see the Permissions icon, you do not have administrative access to the space. To request admin access, contact an admin user listed on the Details Image shown here page for the space.
To add users or groups to a space, enter the new group or user and click Add.
To change permissions for a user or group, select or deselect permissions. Or, click Select All or Deselect All.
Note: View permission is a minimum requirement for any user or group and is not removable.
To remove a user or group from a space, click Remove Image shown here.
Types of Space Permissions
A JMP Live admin or JMP Live users who have administrative access to a space can assign the following permissions to any user or group in a space:
View
User can view posts in the space.
Download
User can download data tables and scripts (that are set as downloadable) or can download report posts or entire folders as JMP Projects in the space.
Create
User can create (publish) new posts in the space.
Edit
User can edit all posts in the space, which includes moving posts or folders within the space. To move posts to a different space, the user also needs Delete permission in the space, and Create permission in the destination space.
Note: It is not possible to move folders between spaces.
Replace
User can replace posts in the space.
Delete
User can delete posts in the space.
Data Admin
(JMP Live only) User can manage data tables (update, upload, refresh, assign credentials, set a refresh schedule) in the space.
Space Admin
User can manage the space, add members or groups, delete members or groups, and change permissions on members or groups.
Caution: If you are a space admin and you remove that permission from yourself, only another space admin or a JMP Live admin can add it back for you.
Open a Post or Folder in a Space
You can open folders, report posts, or data posts in your personal space or spaces where you have View permission.
In a space, click Posts Image shown here, then:
Click a folder to open it.
Click the Reports tab to see all report posts in the folder or space. Click a report post to open it.
Click the Files tab to see all data posts, report posts, and any subfolders in the folder or space. Click a data or report post or folder to open it.
For more details, see Open a Post.
Add Folders to a Space
You can add any number and level of folders to your personal space or spaces where you have Create permission.
1.
In a space, click Posts Image shown here.
2.
At right, click Create folder Image shown here.
3.
Add a title.
4.
(Optional) Add a description.
5.
Click Create.
Update a Folder’s Details
You can update the title, description, or image thumbnail for folders that you create. You can also update folders in spaces where you have Edit permission.
1.
In a space, at left, click Posts Image shown here.
2.
Click a folder.
3.
At the top, click Details Image shown here.
4.
To change the title or description:
a.
Click Edit Image shown here.
b.
Enter your text.
c.
Click Save.
5.
To change the image thumbnail:
a.
Hover over the thumbnail and click Change Thumbnail.
b.
Navigate to an image on your computer and click Open.
Move a Folder
You can move folders that you create. You can also move folders in spaces where you have Edit permission.
Note: It is not possible to move folders between spaces.
1.
In a space, at left, click Posts Image shown here.
2.
Click a folder.
3.
At the top, click More Image shown here > Move folder.
4.
Choose the space that you want to move the folder to. You can also choose a folder in the destination space to nest the folder under.
5.
Click Move.
See Details For a Space
For any discoverable space, you can see details, such as a description of the space, the space key (for scripting), the space admins, and attributes. You can also see details for spaces where you have View permission.
In a space, click Details Image shown here.
Figure 1.2 Space Details
Space Details
Make a Space Discoverable
If you have administrator access to a space, you can set it to be discoverable or not discoverable. Discoverable spaces appear to all users on the Spaces page.
JMP Live Posts
Find out what you can do with JMP Live report or data posts:
Tip: See also JMP Live Data.
Open a Post
You can open posts that you create or posts in spaces where you have View permission.
To open a report post from the Home or Featured pages, click a report title.
To open a report or a data post from a space:
1.
At left, click Posts Image shown here.
2.
(Optional) Click a folder.
3.
Click a report title in the Reports tab. To open a data post, click the Files tab and click a data title.
Figure 1.3 Posts in a Space and Folder
Posts in a Space and Folder
Tip: To move between several posts in a folder, use the navigation icons Image shown here. Or using a keyboard, press the Tab key to get to the navigation icons, then press Enter.
Open a Post in JMP
If you have JMP and you have a JMP Live connection, you can open a JMP Live post in JMP. From a post, click Open in JMP Image shown here. The content is downloaded to your machine and opens in JMP as a JMP Project. See Download Posts as JMP Projects.
Update Post Details
You can update the title, thumbnail image, description, or settings for a JMP Live post that you own. You can also update posts in spaces where you have Edit permission.
1.
From a post, click Details Image shown here. From a post summary, click More Image shown here > Details.
2.
Next to the section that you want to update, click Edit Image shown here.
Tip: In the post description, you can use these HTML tags: <a href= "target">, <b>, <em>, <i>, <strong>, and <u>.
3.
To change the thumbnail image, hover over the thumbnail and click Change Thumbnail.
Figure 1.4 Update a Post’s Details
Update a Post’s Details
Move a Post
You can move posts that you create. You can also move posts within spaces where you have Edit permission. To move posts from one space to another, you need Edit and Delete permission in the source space and Create permission in the destination space.
Tip: For help with permissions, contact the space admin. You can find out who the space admin is by clicking Details Image shown here in a space.
To move a single post, from the post summary, click More Image shown here > Move post.
Figure 1.5 Move a Post
Move a Post
Move multiple posts at once
1.
In a space, at left, click Posts Image shown here.
2.
If the post is in a folder, navigate to the folder.
3.
Click the Files tab.
4.
Select the check boxes of the posts that you want to move.
5.
At the top, click Move posts Image shown here.
6.
Choose the space that you want to move the folder to. You can also choose a folder in the destination space.
7.
Click Move.
Tip: See also Move a Folder.
Comment on a Post
You can see or add comments to a JMP Live post or folder in spaces where you have View permission.
Tip: In a post summary, you can see how many user comments are on a post next to the Comments icon Image shown here.
1.
In a post or folder, click Image shown here or Image shown here.
Any existing comments appear.
Note: In addition to user comments, you might also see system comments, which are mainly informative. System comments are not included in the comment count.
2.
In the Write your comment here box, enter a comment. To respond to an existing comment, click Reply and enter a comment.
Tip: You can use basic HTML, such as bold (<b> or <strong>), italics (<i> or <em>), preformatted (<pre>), or underline (<u>). You can also use markdown, such as headings (#, ##, etc.), bold (**text**), and italics (*text*).
3.
Click Submit.
4.
(Optional) To edit or delete your comments, click More Image shown here and select Edit or Delete. To delete all comments on a post you own, next to the number of comments, click More Image shown here > Delete all.
Assuming that you do not turn off these notifications, you get a notification in these situations:
If someone adds or replies to a comment on a post that you own
If someone replies to a comment that you made
If someone deletes a comment that you made
Share a Post
In a post, click Share Image shown here or if you do not see the Share icon, click More Image shown here > Share.
You can share a post in any of these ways:
On social media, such as Facebook, Twitter, LinkedIn
Note: These options do not appear if your JMP Live administrator has disabled them.
Email or copy a link
Copy embedded HTML code (for a web page)
Figure 1.6 Sharing Options
Sharing Options
Bookmark a Post or Folder
You can bookmark JMP Live posts or folders in spaces where you have View permission.
In a post or folder, click Bookmark Image shown here.
To see all your bookmarked posts and folders, at the top right, click Bookmarks Image shown here.
To remove a bookmark, click Unbookmark Image shown here.
Figure 1.7 Example of the Bookmarks Page
Example of the Bookmarks Page
Delete Posts
You can delete posts or folders that you published. You can also delete posts or folders in spaces where you have Delete permission. However, you can not delete a data post if a JMP Live post is using the data.
To delete a single JMP Live post or a folder from a post, space, or post summary, click More Image shown here > Delete post.
Figure 1.8 Delete a Post
Delete a Post
Delete several posts or folders
1.
In a space, click Posts Image shown here.
2.
Click the Files tab.
3.
Select the posts that you want to delete. To select all posts, click the box next to Title.
4.
At the top, click Delete selected posts Image shown here.
5.
Click Confirm.
Manage Notifications on Posts
As a JMP Live, depending on your notification settings, you can be notified about comments, changes to posts, changes to your access settings, control chart warnings, and more.
Open or Act on Notifications
To see your notifications, click Notifications Image shown here. From here, you can perform the following actions:
To open the source, such as a post, click a notification.
To clear a notification, click More Image shown here > Clear notification.
To stop receiving notifications of a certain type, click More Image shown here > Stop receiving <type> notifications.
To mark all notifications read, click Mark All as Read Image shown here.
To remove all notifications, click Clear All Image shown here.
To change your notification settings, click Settings Image shown here. See Change Notification Settings.
To see all notifications in a larger window, click See All.
Change Notification Settings
Access your notification settings in either of these ways:
At the top right, click your user icon > Settings. At left, click Notifications Image shown here.
Click Notifications Image shown here and click Settings Image shown here.
Enable or disable notifications. If you enable a notification, choose how often you want to be notified.
Figure 1.9 Notification Settings
Notification Settings
Tip: To sort notifications by ascending or descending order, click the arrow next to Notification.
Download Posts as JMP Projects
If you want to open several files from JMP Live in JMP, download the post and any related content (such as data) as a JMP project file. A project file keeps all of the post’s content in one tabbed window in JMP. Content associated with a post can include data tables, scripts, maps, or images.
You can download posts or folders that you published as JMP Projects. You can also download posts or folders in spaces where you have Download permission as JMP Projects. However, you can not download posts that have been set to disallow downloading.
Download a post or folder as a JMP project
From a post or folder, click More Image shown here > Download as JMP project.
Note: If you can not access this option, your JMP Live admin might have disabled downloading. Contact your admin.
For details about projects, see Work with Projects in the JMP Help.
See Post Accesses
To see who has accessed a JMP Live post or a folder that you created, from a post or folder, click More Image shown here > Advanced > View accesses.
For a single post or folder, you can see the following details:
who has accessed the post or folder
whether the person viewed the post or folder
whether the person downloaded the post or folder
when the person accessed the post or folder
Flag Posts or Users
If you think a JMP Live post or user profile contains inappropriate content, you can flag it to the JMP Live administrator:
1.
Do one of the following actions:
To flag a post: On a post summary or from a post, click More Image shown here > Flag as inappropriate.
To flag a user profile: From a user profile, click More Image shown here > Report user.
2.
(Optional) Add comments to explain the issue.
3.
Click Submit.
Here is what happens when a post or user profile is flagged:
1.
JMP Live administrators determine whether a flagged post should be cleared (the flag removed), hidden, or removed, and whether a flagged user profile should be cleared or hidden.
2.
If the JMP Live administrator hides or removes a flagged post, or hides a flagged user profile, the owner of the post or the flagged user is notified (if they have not turned off notifications for flags). For hidden posts or users, the owner or user can attempt to fix the problem and let the administrator know. The administrator can then reinstate the post or user if they approve.
Change the Format of Posts
At the top right, click an icon to change the format of JMP Live post summaries:
Image shown here
The grid format shows cards with image thumbnails.
Image shown here
The list format shows a list with image thumbnails.
Image shown here
The compact list format shows a list with no image thumbnails.
See Performance Metrics on a Report Post
From a post, at top right, click More Image shown here > Advanced > Display performance metrics. You can see how long it took the post to load, copy the metrics, or clear the metrics.
Show Log Messages for a Report Post
In a JMP Live report post, you can click More Image shown here > Display log messages to see any error messages from the server, connection messages, and messages from the client.
Copy a Post ID for Scripting
From a post, at top right, click More Image shown here > Advanced > Copy ID to clipboard. You can also copy the post ID from the Details panel. The post ID is used for JSL scripting.
JMP Live Graphs
Find out what you can do with JMP Live graphs:
See Data Values in Graphs
In a JMP Live report post, you can see information about data points in graphs or report calculations.
1.
Click or tap Identify Objects Image shown here.
2.
Hover over or tap a data point or a calculation.
Figure 1.10 See a Data Point’s Values
See a Data Point’s Values
Figure 1.11 See an Explanation of a P-Value Calculation
See an Explanation of a P-Value Calculation
Tip: To hide or show reports and graphs, at the right of a title, click or tap the arrow.
Select Data in Graphs
In a JMP Live graph, you can select data or zoom in on data.
How you select data in a JMP graph (points, bars, and so on) depends on whether you are on a computer or a mobile device. The default mode is to select a single data point.
On a computer
On a mobile device
Select or deselect a single data point
Click a data point.
Tap Select One Object Image shown here then tap a data point.
Select or deselect multiple data points
Hold down the Shift key and click multiple data points.
Tap Select Multiple Objects Image shown here then tap multiple data points.
Identify a single data point
Hover over a single data point.
Tap Identify Objects Image shown here then tap a data point.
Select data points by brushing
Click and drag a rectangle over data points. Click and drag in the center to move the rectangle, or drag the corners to resize it.
Tap Select Multiple Objects Image shown here then draw a rectangle over the data points. Drag the center to move the rectangle, or drag the corners to resize it.
Zoom
Click Magnifier Image shown here and click a point or drag a rectangle. The center of the rectangle is now the center of the zoom area.
To zoom out, double-click in the graph, or press Shift and click in the graph.
You can also use the scroll wheel on your mouse to zoom in and out. If you are not in Zoom mode, press Alt before zooming with the scroll wheel.
Tap Magnifier Image shown here and pinch zoom.
Pan in a graph
Click Grabber Image shown here and click and drag in the graph. Or, press Alt and click and drag in the graph.
Tap Grabber Image shown here and move the graph with your finger.
Pan axes
Click the middle of an axis and drag.
Touch the middle of an axis and drag.
Scale axes
Click at either end of an axis and drag.
Touch either end of an axis and drag.
Return axes or graphs to their original state
Press Alt and double-click in the graph, or click More Image shown here or Image shown here > Reset all axes.
Double-tap in the graph, or tap More Image shown here > Reset all axes.
Note: In interactive HTML, some graphs do not support panning and zooming. Panning and zooming is fully supported in JMP Live and JMP Public.
See Linked Data in Graphs
If your JMP Live report post contains multiple JMP graphs, when you select data in one graph, it is highlighted in all graphs.
Figure 1.12 Select Data in Linked Graphs
Select Data in Linked Graphs
In this example, a histogram bar in the top graph is selected. The corresponding rows are highlighted in the scatterplot and in the marginal histogram.
Exclude and Hide Data in Graphs
Once you have selected data in a JMP graph, you can exclude it from report calculations and hide it in graphs. Reports and graphs automatically update.
Figure 1.13 Report Menu Options
Report Menu Options
To exclude and hide data, right-click in the graph, or use the options in the More Image shown here menu on the right:
Note: If the report contains a Local Data Filter, most of these options do not appear, since you use the Local Data Filter instead.
Exclude and hide selected rows: Excludes and hides selected data.
Include and show all rows: Includes and shows any excluded or hidden data.
Invert row selection: Changes the current selection to the deselected data.
Filter Data in Graphs
If the original JMP report included a Local Data Filter, you can use the filter to focus on specific data and see the impact on JMP Live graphs and reports.
Figure 1.14 Filter Data in Graphs
Filter Data in Graphs
Tip: Selections that you make in the Local Data Filter are captured in the URL. You can copy and paste the URL to share your selections with others.
In this example, the filter choices are showing only females between 51 and 63 inches tall who are between the ages of 12 and 14.
Tip: If several categories are selected and you want to select a single category, click the category (not the check box).
Local Data Filter Options
Conditional Filtering
Limits the options in the Local Data Filter by condition. For more information, see Using JMP.
Note: This option does not appear if there is more than one OR group, or if the columns are not hierarchical.
Select filtered rows in graphs
Selects all filtered rows in graphs.
Show filtered rows in graphs
Shows all filtered rows in graphs.
Include filtered rows in calculations
(JMP Live and JMP Public only) Only filtered rows are included in report calculations.
Auto update
(JMP Live and JMP Public only) Enables automatic updates to the local data filter.
Inverse
Inverts currently selected filters.
Manually Update Data Filters
If a report is taking a long time to automatically update, you can manually update the data filter selections instead.
1.
Click Auto Update to deselect this option.
2.
Make your changes to the local data filter.
The graphs do not update as you make your changes.
3.
Click Update.
Switch Data Columns in Graphs
If the original JMP report included a Column Switcher, you can quickly analyze different variables without re-creating the analysis. When you choose a different variable in JMP Live, the analyses automatically recalculate using the new variable.
In this example, using Fisher’s Iris data, the JMP report post includes a Column Switcher and a Local Data Filter.
Figure 1.15 Initial Selections
Initial Selections
Initially, Petal length (the original column) is selected in the Column Switcher. All species are showing in the Local Data Filter. These selections are reflected in the graph and calculations.
Figure 1.16 Updated Selections
Updated Selections
Here, Petal width is selected in the Column Switcher, and only the species versicolor is selected in the Local Data Filter. The graph and calculations update to reflect these selections.
Tip: Selections that you make in the Local Data Filter and Column Switcher are captured in the URL. You can copy and paste the URL to share your selections with others.
Control Chart Warnings in Graphs
JMP Live report posts containing control charts can generate notifications if there are control chart warnings. When you publish a JMP report post that contains a control chart, you can specify whether to enable warnings. You can also enable warnings from a JMP Live report post.
These people receive notifications:
The publisher of the post
Users who subscribe to warnings for a space, folder, or post
Users who are members of a group with control chart warnings enabled
Depending on individual settings, notifications appear in JMP Live and via email. Email notifications contain more detail about the warnings. See Manage Notifications on Posts.
Subscribe to warnings
1.
In a space, folder, or post containing control charts, click More Image shown here > Subscriptions.
2.
Click to subscribe to control chart warnings in a space, folder, or on a post.
Enable or disable warnings
You can enable or disable warnings on posts that you own or posts in spaces where you have Edit permission.
1.
In a report post that contains a control chart, click Details Image shown here or Warnings Image shown here.
2.
Next to Warnings, click the switch to turn them on or off.
3.
(Warnings on only) If the report post has active warnings, choose whether to notify people about these warnings.
See details about warnings
1.
In a report post or from a thumbnail, click Warnings Image shown here.
2.
You might need to click Expand to open the Warnings pane.
Figure 1.17 Example of Control Chart Warnings
Example of Control Chart Warnings
3.
(Optional) For more detailed information, click Open Log.
To copy the log information, click Copy Image shown here.
Note: If you filter data or change row states (for example, if you exclude or hide rows) control chart warnings are not triggered or updated in JMP Live. Any warnings in JMP Live appear as captured when the data was originally published.
Customize Graphs
Note: These customizations are temporary while you are in the JMP Live post.
To resize a graph in JMP Live, click and drag on the graph borders. You can also resize a scrollable report in a JMP Live dashboard.
Use the options in the More Image shown here menu to customize graph elements.
Figure 1.18 Change the Marker Size
Change the Marker Size
The options in this menu can vary depending on the type of graph or JMP platform. For example:
In scatterplots and histograms, you can change the marker size.
In profilers, you can reset the profiler to its original state, or re-scale the vertical axis to include the response.
In data filters, you can choose how you want to filter data.
In bubble plots, you can change the appearance of the bubbles, add a time label, or change the aggregation method.
JMP Live Data
Find out what you can do with data in JMP Live:
View a Data Table
1.
In a space or folder, click the Files tab.
2.
Click a data post Image shown here.
3.
Click View Data.
Figure 1.19 Example Data Table
Example Data Table
In the Columns panel, you can do any of these actions:
hide or show columns by selecting them and then clicking Apply
search for a column, or filter columns Image shown here by data or modeling type
see information about a column Image shown here
Tip: See also JMP Live Posts.
Download Data or Scripts
When you publish content to JMP Live, you can specify whether to allow users to download the data and script associated with the post. You can also change the download setting from a JMP Live post.
You can download data that you published. You can also download data in spaces where you have Download permission. However, you can not download posts that have been set to disallow downloading.
Change the download setting from a post
1.
In a post, click Details Image shown here.
2.
Under Settings, next to Allow download, click Edit Image shown here.
Note: If you can not access this option, your JMP Live admin might have disabled downloading. Contact your admin.
3.
Select or deselect Allow download.
For a report post, this option impacts the associated script. For a data post, this option impacts the associated data.
4.
Click Save.
Download data or scripts
5.
In a post, click Details Image shown here.
6.
Under Data Table or Script, click Download Image shown here or More Image shown here > Download.
7.
(Optional) To copy a script, click Copy Image shown here.
Note: If the publisher chose not to allow downloading, the Script pane and download options do not appear to other users.
Update Data
If the data associated with a report post changes, you can update the data in JMP Live without republishing. The report post updates automatically once the data is updated.
You can update data that you published. You can also update data in spaces where you have Data Admin permission. The data must also be set to downloadable.
1.
In a space or folder, click the Files tab.
2.
Click a data post Image shown here.
3.
Click Update Data.
4.
Click Attachment Image shown here.
5.
Navigate to the updated data table on your computer and click Open.
6.
Click Submit.
7.
(Optional) To undo the update and revert to the previous version, click Undo Recent Updates, and then click Revert.
Schedule Data to Refresh
In JMP Live, you can schedule data to refresh in spaces where you have Data Admin permission.
1.
Create a refresh script to generate the data table. See Create a Refresh Script.
2.
(Optional) Add and assign any required credentials. See Assign Credentials.
3.
Turn on the refresh. See Refresh Data on Demand.
4.
Schedule the data to refresh at intervals. See Schedule a Refresh.
Create a Refresh Script
Create a refresh script that creates and returns a data table. Your script can include JSL commands to perform actions on the data such as recoding and so on.
1.
In a space or folder, click the Files tab.
2.
Click a data post Image shown here.
3.
Click Settings.
4.
Create the refresh script using JSL.
5.
Next to Refresh Script, click Edit.
6.
Paste your refresh script.
7.
Click Save.
8.
Under Refresh Settings, turn on Refreshable.
Figure 1.20 Example of a Refresh Script
Add or Update Credentials
1.
At the top right, click your user icon > Settings.
2.
At left, click Credentials Image shown here.
3.
To update credentials:
Click Edit Image shown here. Update the credential name. Click Update credential to modify the user name and password.
To delete a credential, click Delete Image shown here.
4.
To add a new credential, click Add stored credential Image shown here.
Figure 1.21 Add Your Stored Credentials
5.
Name the credential.
Tip: Use a name that helps you identify the credential, such as the name of the database.
6.
Enter the user name and password for the credential.
7.
Click Save.
Assign Credentials
If any JSL commands in your refresh script require credentials to access an external server or database, you can securely add and assign those credentials. In the refresh script, your credentials are represented by generic placeholders and are not visible.
1.
In a space or folder, click the Files tab.
2.
Click a data post Image shown here.
3.
Make sure you have created a refresh script. See Create a Refresh Script.
4.
Next to Assigned Credentials, click Assign.
Figure 1.22 Assign an Existing Credential
5.
To create a new credential, click Add stored credential Image shown here. Name the credential, enter the user name and password, and click Save. See Add or Update Credentials.
6.
Select the credential that you want to use.
7.
(Optional) Click Set as default to make the credential available in the refresh script.
8.
Click Save.
Refresh Data on Demand
1.
In a space or folder, click the Files tab.
2.
Click a data post Image shown here.
3.
Click Settings.
4.
Make sure you have created a refresh script. See Create a Refresh Script.
5.
If your data comes from a third party and uses credentials, make sure you create and store the credentials in JMP Live. See Assign Credentials.
6.
Click Refresh Data > Confirm.
Schedule a Refresh
You can schedule data to refresh as frequently as every 5 minutes, or as infrequent as once per week. You can also have several schedules for a data post. For example, one schedule might be to refresh the data every Tuesday at 9pm, and another schedule might be to also refresh the data hourly every Friday from 8am until 5pm.
Note: Schedules are based on the time zone that your JMP Live server is in.
1.
In a space or folder, click the Files tab.
2.
Click a data post Image shown here.
3.
Click Settings.
4.
Make sure you have created a refresh script. See Create a Refresh Script.
5.
If your data comes from a third party and uses credentials, make sure you create and store the credentials in JMP Live. See Assign Credentials.
6.
Next to Refresh Schedules, click Create.
Figure 1.23 Create a Refresh Schedule
7.
Select the following details:
Time for the refresh to start
Days of the week to run the refresh
(Optional) To repeatedly refresh data during a time period, specify how often to repeat the refresh and what time to stop refreshing the data.
(Optional) Set a date for the refresh to expire. The expiration date is inclusive, so the refresh expires at 11:59pm on the day.
8.
Click Save.
9.
Under Refresh Schedules, you can enable, edit, or delete a schedule.
Example of Refreshing Data
This example contains the following steps:
Import the Data and Create a Report in JMP
1.
Use Query Builder to import data from a database into a JMP data table. For details, see the section on building SQL queries in the Using JMP book.
Figure 1.24 Example of Imported Data with Source Script
The resulting data table contains a Source script that gets the data again without running Query Builder. This Source script can be used to create the refresh script.
2.
Create a report based on this data. This example creates a Distribution report for several variables.
Figure 1.25 Distribution Report
3.
Publish the report and associated data (and Source script) to JMP Live.
Create a Refresh Script in JMP Live
1.
Open the data in JMP Live and click the Settings tab.
Figure 1.26 Settings Tab for Data in JMP Live
The Source Script panel contains the Source script from the data table.
2.
Next to Source Script, click Copy.
3.
Next to Refresh Script, click Edit.
4.
Paste the Source script that you copied.
5.
Edit the Source script as follows:
At the beginning of the script, add dt = before New SQL Query.
At the end of the script, add a new line with dt;.
6.
Click Save.
7.
Click Refreshable to turn it on.
Create and Assign Credentials in JMP Live
Notice that in the Source and Refresh scripts, your user ID and password for the database are replaced with %_PWD_% and %_UID_%. You need to create and assign your database credentials, which are then substituted into the PWD and UID placeholders when the refresh script is run. JMP Live securely stores these credentials in its own database.
1.
Next to Assigned Credentials, click Assign.
2.
Click Add stored credential Image shown here.
3.
Add an identifying name for the credential and your user ID and password for the database. For details, see See Assign Credentials.
4.
Click Save.
5.
Select the new credential and click Save.
6.
Click Refresh Data > Confirm.
Create a Schedule to Refresh Data in JMP Live
1.
Next to Refresh Schedules, click Create.
2.
Under Start Time, click the box and change the time. In this example, the time is set to 5pm.
3.
Under Runs On, click the days that you do not want the refresh to run. In this example, S and S (Saturday and Sunday) are deselected.
Figure 1.27 Create a Refresh Schedule
4.
Click Save.
This refresh script runs every weekday at 5 pm. The data and any reports that use the data are refreshed and recalculated.
Tip: To see the results of a refresh, click the History tab. You can see when the script ran and if it was successful.
Search JMP Live
To search all of JMP Live for posts, users, or spaces, enter a keyword in the search box at top right. Click Posts, Users, or Spaces to see specific types of results.
Figure 1.28 Example of Searching by Keyword
Example of Searching by Keyword
Here are some things that you can do from the search results:
Posts
To open a post, click the title or image.
To open the post author’s profile, click their user name.
To open a space or folder, click the title.
To bookmark a post, click Bookmark Image shown here.
To flag a post as inappropriate, click More Image shown here > Flag as inappropriate.
To copy the post ID for scripting, click More Image shown here > Copy ID to clipboard.
To move or delete a post that you own, click More Image shown here > Move post or Delete post.
Users
To follow a user, click Follow.
To open a user’s profile, click their user name.
Spaces
To open a space, click the space.
Use Filters in JMP Live Searches
You can use filters to narrow your searches on JMP Live posts or spaces.
Filter Posts
1.
Click Home.
2.
At the top right, click Filters Image shown here.
Figure 1.29 Filter Options on Posts
Filter Options on Posts
3.
Enter any combination of keywords, user or space names, or dates.
4.
Click outside of the Filters pane to see the results.
5.
To stop filtering, click Clear Filters.
Filter Spaces
1.
Click Spaces.
2.
At the top right, click Filters Image shown here.
Figure 1.30 Filter Options on Spaces
Filter Options on Spaces
3.
Enter keywords in the Find text box. You can also select a space type.
4.
Click outside of the Filters pane to see the results.
5.
To stop filtering, click Clear Filters.
Update Your JMP Live Profile or Settings
You can update the following aspects of your profile or JMP Live settings:
Update Your Profile Picture or Display Name
1.
At the top right, click your user icon > Settings.
2.
Next to Avatar, click Edit Image shown here > Upload new avatar or Reset to default.
3.
Next to Display Name, click Edit Image shown here and enter and save your new name.
Note: The ability to edit your display name depends on your authentication settings.
Figure 1.31 Edit Your Profile Picture or Display Name
Edit Your Profile Picture or Display Name
Verify your account details
1.
At the top right, click your user icon > Settings.
2.
Verify your login name or the email associated with your account.
3.
(Local authentication method only) Verify or change your password.
Change Your Language
At the top right, click your user icon > Language and select a language.
Change the Theme to Dark or Light Mode
To change the theme from light mode to dark mode, at the top right, click your profile picture > Dark mode.
Figure 1.32 Change the Theme
Change the Theme
Get an API Key for Scripting
Before you can use scripting to publish content to JMP Live, you might need an API key. (JMP Live administrators determine whether an API key is required for scripting.) An API key is unique for a user and a JMP Live server.
Caution: If you are updating an API key, it overrides the existing key. That means that any existing scripts that use the old key must be updated to use the new key.
1.
At the top right, click your user icon > Settings.
2.
Under API Key, click Generate New API Key Image shown here.
You can also view your API key or copy it for inclusion in JSL scripts.