While the Query Builder is quite useful for joining tables, there is another feature in JMP 13 that lets you bring all the power of a join without having to take up the memory footprint – the Virtual Join. It’s also a really useful tool for prototyping SQL, can be a bridge between disparate data sources and is much easier than specifying all the detail in the Join command largely due to the fact that you get an informative preview of the results before running the command. You can join up to 64 JMP tables, set up prompting filters, make summaries, groups and sorting options and run post-query scripts. It brings all of the features from the Query Builders for databases and SAS tables, but to JMP tables. The Query Builder for JMP tables is the latest addition to the Tables menu and the Query Builder family. If you’ve experienced the challenge of joining more than two tables using Tables > Join, I have your new favorite feature in JMP 13. If you’ve ever had a data table with script names such as Distribution 1 – Distribution 24, you’ll appreciate this improvement as well. As a bonus, when you save scripts to the data table, they are named with a bit more detail than in previous versions of JMP. Simply click the big green play button and your script runs. No longer do you need to click the red triangle in a data table script and then be faced with options such as Run Script, Edit or Delete (although these still are available with a right-click). This also makes running scripts a bit less scary for novice JMP users. We’ve reduced the number of clicks required to re-run an analysis script to a one. So when you get your copy of JMP 13, try out some of these new features and enhancements, and let me know what your favorites are. There are just too many things I would miss. For me, after using JMP 13, there is no going back. I’ve been using JMP 13 during the entire development cycle (about 18 months now), and I am impressed how this version has really changed the way I use JMP. JMP 13 is coming this week, and I am quite excited about this release. There's a lot in JMP 13 to tell your friends about, starting with one-click re-running of analysis scripts and a quick way to join lots of data tables. The graphs shown here as well as a few other examples are available as live interactive HTML files to explore on the web at, but be sure to try your own Graph Builder creations! These are just a few examples of the powerful graphs you can create to explore your data in Graph Builder and share with others using interactive HTML. Here, a mosaic plot, bars and histograms are combined to analyze the importance of different goals to schoolchildren. In JMP, you can use Dashboard Builder to create reports with several types of Graph Builder output in the same page - so people who do not have JMP yet can interactively explore your data. Cells give informative tooltips regarding the share and number of rows associated with each cell, and cells can be selected with rows being linked to other related charts in the report. Below is an example created using Titanic passenger data to examine the distribution of ages.Ī mosaic plot is used to examine the relationship between two categorical variables. The histogram is available in Interactive HTML in the Distribution platform (as well as options in several other JMP platforms), but now can also be exported to the web after exploring your data in a drag-and-drop manner in Graph Builder in JMP. What if you want to bin data into categories to explore their distribution? There are a number of ways to do this in Graph Builder. Below you can see the close relationship between the violin plot and another Graph Builder element, the box plot. Contour plots are exported as static images however, if your data is categorical, Graph Builder produces violin plots, which are exported as interactive HTML. While the most heavily used graph types and options are exported as interactive HTML, the remaining ones are exported as static images. The example below combines lines using different drawing styles with annotations and the gray reference ranges to create a rich graph. Graph Builder gives you the ability to customize various attributes of the lines. The tooltips for lines display the rows that are included in each point along the line as well as information about the values. Exploring these stacked areas in interactive HTML, you can now see the values along the edge of the area. Areas and lines can be used to display some of the same information as points but in a different way. Getting Graph Builder output to work for the web in JMP 13 involved bringing new features to several graphical elements that had been available in interactive HTML output since JMP 11. By now you may have heard that in JMP 13, the most frequently used features of reports created in Graph Builder can be saved as interactive HTML, which can then be viewed using just a web browser.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |