JMP supports many date/time formats, but some less conventional (or downright esoteric) formats still crop up from time to time. To many users, converting an oddly formatted date/time from string to numeric form is a frustrating endeavor, requiring custom formulas and an assortment of seldom-used string and numeric operations. With
Tag: Tips and Tricks
As data analysts, we all try to do the right thing. When there is a choice of statistical distributions to be used for a given application, it’s a natural inclination to try to find the “best” one. But beware... Fishing for the best distribution can lead you into a trap.
Syntax got your tongue? I've compiled 13 JMP Scripting Language tips that I've found handy while learning JSL syntax: 1. Concatenating strings (see Craige Hales' post on this) places = {"world", "planet", "globe", "Earth"}; statement = "Hello " || places[2] || "!"; The above code creates the string "Hello planet!" 2. Referring to table column
Let's say you are in the Distribution platform in JMP, and you have created a report that you wish to drill down into. Well, the Local Data Filter can help with that. But perhaps you also want to share a portion of the data with a co-worker, and not just
Joining tables that are open in JMP is a task we often need to do when collecting and combining data from different sources or observation dates. Plus, you may want to customize your join further, for example, by matching specific columns or even leaving out a few columns. Watch the demo
The little red triangles in JMP are ubiquitous, hard-working and powerful! Here's a quick video by my colleague Ryan DeWitt on these drop-down menus that some users call "hot spots," "inverted triangles" or just plain old "triangles." Subscribe to the JMP channel on YouTube to see the latest videos.
A fellow consultant has advised that, when working on submissions for a regulatory agency, you should “model” your submission on previous ones (that is, leverage previous successful work to your benefit). In that spirit, I fully admit to “modeling” this blog post on those by Jeff Perkinson (10 Things You
Since it debuted earlier this year, the New User Welcome Kit has become one of the most fun and efficient ways to learn how to use JMP. Now it’s been updated with six new hands-on activities that let you apply your skills within JMP itself. The new activities include: Using Graph
Previously, I shared a list of things you probably didn't know about JMP. Maybe you already knew some of them. Maybe you learned a few new things; I hope you did. Well, now here are five more things you probably don't know about JMP. 1. Row State columns There are
The title of this post is provocative, I know. But if you read this list, I'll bet you'll find something that you didn't know about. Now, if it turns out that you already knew most of these, I do want to know. Take a moment, let me know and add