Welcome to the JMP User Community!

Latest Discussions

• Check if multiple column values fall within range

  Sample table:PartTest 1Test 2Test 3Test 4A0.20.40.30.1B0.20.30.40.6C0.70.10.20.4I would like to add a column to this table that evaluates every value in columns Test 1-Test 4, and if all fall within a range to output "Yes".For example, if my range was 0 < values < 0.5, the output would look like this (I've highlighted failing values in red)PartTest 1Test 2Test 3Test 4Yes/NoA0.20.40.30.1YesB0.20.30...

  hooshies

  Discussions |

  Sep 23, 2015 8:45 AM

  12842 views | 4 replies

• Using colour/markers for better multivariate visualisation

  I am exploring the best ways to present multivariate data for further exploration. Experience has shown it can be difficult for people to grasp what scores and loadings plots in PCA are telling them and how similar different clusters are to each other. I can get T2 values from the multivariate control chart platform (after specifying a training group), and the critical value using the formula in t...

  stephen_pearson

  Discussions |

  Sep 23, 2015 2:52 AM

  8466 views | 1 replies

• Calculations using the Tabulate function

  I've been using the Tabulate function to provide summaries of data tables. I'm trying to compare the % change between two sums for multiple groups.
  
  Is there a way to add a simple calcuation of two columns summed in Tabulate, like column A / column B? I know I can make this into a data table, but I wanted to include it in a presentation and the formatting looks much better in the Tabulate window...

  rossmiller

  Discussions |

  Sep 22, 2015 7:31 AM

  18251 views | 9 replies

• Lock scales independently in Graph Builder

  In Graph Builder there is an option to lock scales in order to keep the axes from responding to data changes. In JSL, the Lock Scales function is available to do the same. In both the UI and JSL, locking scales affects both the x and y axes. Is there a way to lock the axis scales independently? I have a script, actually several, that generate graphs with Graph Builder, but that also open Data Filt...

  mdawson69

  Discussions |

  Sep 21, 2015 11:17 AM

  12879 views | 5 replies

• What's the forward slash ("/") escape sequence for quoted strings?

  Hi All, I know the JSL backslash escape sequence for quoted strings is \!\.  But what is the equivalent escape sequence for a forward slash?  Does one even exist in JSL?  I did not see any references in the JSL scripting guide (p. 85).  thx, dj

  djhanson

  Discussions |

  Sep 19, 2015 7:06 AM

  12583 views | 1 replies