About BHarris

BHarris

While I think the heat-plot is closer to what I was looking for, the maps suggestion made me look into maps which have a pretty elegant implementation, and I'm excited to use them elsewhere. Thanks for the tip!!

BHarris

Looks like you can't do the above directly from the GUI (right?) because the "aggregate" transform doesn't know which X and Y to use (right?). (Thank you for all the info, this is super interesting and helpful! I'm slowly converting people at my work into JMP users... 😉 )

BHarris

Quick follow-on -- if I put a variable on "color", and there are multiple values in the data table for that color-block, which statistic does it use? mean? It'd be nice if it gave you the option to change that...

BHarris

Awesome! This is exactly what we needed, thank you! We will be using this a lot.

BHarris

This took me awhile to figure out what it was doing ... so the "Freq" box uses the variable "z" to indicate "how many times" a combination, e.g. green/b, shows up? Then the legend shows you that count? Also, am I right that frequency can't be negative here?

BHarris

Can I just say, that's incredibly unintuitive to my brain -- I never would've thought to look there. Why was that feature put there? Is there something special about the fit-y-by-x manipulation of the data that makes the CDF possible? (I've used this many dozen times since you responded to this, thanks again for your help!!)

BHarris

I notice that one of the column properties is "units", which assume to mean things like "feet", "kilometers", etc. Is there a hidden feature that will allow the user to change the column to different units easily? E.g., if input data is in "feet", the user could right click the column header and see an option to change the units to "meters" and the column values would change? Also, if JMP could detect the units from the column header, e.g. len(m) = length in meters --> column header as "len" and units as "meters".

BHarris

I notice that one of the column properties is "units", which assume to mean things like "feet", "kilometers", etc. Is there a hidden feature that will allow the user to change the column to different units easily? E.g., if input data is in "feet", the user could right click the column header and see an option to change the units to "meters" and the column values would change?

BHarris

I often find myself trying to make "quilt" plots (see attached) using Graph Builder, but the only way I can find to do it is to make very large square-markered dots in the points plot, then try to resize the plot window perfectly and hope that it doesn't reset the marker settings in the process. Is there a better way to make plots like this?

BHarris

I've noticed when I plot dot plots in Graph Builder that if I have above a certain number of dots, it starts printing them as tiny oddly shaped dots and starts to ignore the marker settings. Why does it do that? Can I prevent it from doing that?

BHarris

Suppose I have a dataset of heights of men and women in a university, is it possible to plot two cumulative distribution function (CDF) lines on the same plot, one for men and one for women?

BHarris · ‎06-02-2020

Wow, that's some impressive sorcery! That worked! Curiously, the x-axis label is mostly cut off in the copy, I wonder why that would be? I tried shrinking the font and that made it worse. Mac JMP v14.2.

BHarris · ‎06-02-2020

This is very close!! It copies the entire window contents, which includes the local data filter, the "Graph Builder" gray box, etc. Is there any way to just get the plot itself?

BHarris · ‎06-01-2020

Hm -- that creates a Graph Builder window then pushes it to the Journal, without affecting the clipboard. I need to take an *already existing* Graph Builder window and copy the graph to the clipboard.

BHarris · ‎06-01-2020

Awesome, can't wait.

BHarris · ‎06-01-2020

Is it possible to copy the current Graph Builder plot to the system clipboard using jsl? If so, how?

BHarris · ‎05-06-2020

This is awesome! Wish it had the IMDb rating as a column though. Also looks like it only has old movies...

BHarris · ‎02-03-2020

I just found the Statistics Index for the first time, and it's *great*! I wish I'd found it before... I took 3 college-level statistics courses, and yet I probably only know 10% of the terms in that window. So, my suggestion is to break the terms up by their order of complexity, i.e. roughly by what level statistics course it would be introduced in. Then people who know very little about statistics could click "level 1" (or basic, beginner, etc.) off to the left and only the basic terms (sum, mean, standard deviation, etc.) would show up. You could then almost teach yourself statistics -- or at a minimum make a place in your head for concepts that you haven't learned yet -- by working through the different levels. "All" would be an option that would replicate the current list. I also notice that "statistics", "probability", "residual", and "estimator" aren't in the list but should be. Don't need to put "number" in there, but starting at "statistics" would be a great place for newer users.

BHarris · ‎02-03-2020

FYI, the Mac lets you set your own: https://community.jmp.com/t5/Discussions/Keyboard-shortcuts/m-p/183574/highlight/true#M40301 I have lots set, and it makes JMP truly amazing. People are blown away with how fast I do stuff in JMP (cmd-shift-m = select matching, cmd-shift-i = invert row selection, cmd-shift-h = hide/exclude/unhide/unexclude, cmd-<minus> = delete rows, cmd-shift-b = graph builder, etc.)

BHarris · ‎12-06-2019

Ack! Nevermind, how do I delete this thread? Those dates aren't unique in this dataset. Sorry!

BHarris · ‎12-06-2019

See attached.

BHarris · ‎12-06-2019

I have some temperature data like this: The dailyHigh(f) column is a formula that I'm trying to calculate from the hourly temperature data. I'm using the Col Maximum function, but it's coming up with answers I that aren't right, like that 68 number for 2000-01-01 -- it should be 57.92, not 68. Here's the formula I'm using: I've done this type of formula before, no clue why it isn't working here. Any ideas? Using JMP 14.0.0 on Mac OS.

BHarris · ‎10-23-2019

Sorry I'm so slow, I have no idea how to do that.

BHarris · ‎10-22-2019

I copy/pasted that function out into a new JSL script and ran it, but the Log shows this error: "Cannot redefine a predefined JMP namespace"

BHarris · ‎10-22-2019

I'll look up list parameters, thx. No clue what you're talking about on the double quotation marks, or the basis of the comment about JMP providing custom functions and transforms.

BHarris · ‎10-22-2019

Thanks for the response, Mark! A couple quick follow-on questions: 1. I know JMP *supports* multi-column transform functions -- is it just that it doesn't support multi-column *custom* transforms yet? 2. Your function takes 3 arguments -- is it possible to define a function that takes an arbitrary number of arguments?

BHarris · ‎10-21-2019

The scripting guide is pretty useful in describing how to make new custom transform functions, but it's not very clear on how to handle multiple columns. How do I create a custom transform function that takes multiple columns as inputs? E.g., if I select an X, a Y, and a Z columns and want to take the RSS (root-sum-squared) of those three columns? Also, if the order matters, how is that order set? Is it the order that the columns are selected in?

BHarris · ‎10-20-2019

I just created a custom transform script for unit conversions, e.g. ft to km. Pretty cool that JMP lets me do this. But now I'd like those to be enabled every time I run JMP. I searched for "Startup scripts" and similar, but didn't see any mention anywhere of how to do this. How can I make those custom transforms permanent? Or, how can I have JMP automatically run a .jsl every time I launch it?

BHarris · ‎10-17-2019

Right-click on the column name in the Graph Builder interface? Wow, I had no idea that existed! Thank you!

BHarris · ‎10-17-2019

As a former gnuplot user, I could plot column "0" as one of the axis, and it would plot the row number on that axis. Obviously I could do this with a formula column ("row()"), but is there a way to do this without having to create a new column in my table?

Date Registered	‎07-15-2018 12:08 PM
Date Last Visited	Tuesday
Total Messages Posted	56
Total Kudos Received	38

Online Status	Offline
Date Last Visited	Tuesday