Welcome to the JMP User Community!

Latest Discussions

• What is the easiest way to count the number of occurrences in a column when rows duplicate?

  What is the easiest way to count the number of occurrences in a column when rows duplicate based on another column?I can of course create a new table without duplicate rows or a script, but can this be done with say Tabulate?Example: I want to know how many men and women.  F(n=3) and M(n=2).Person    Sex   1               F2               F2               F3               M3               M4      ...

  mri

  Discussions |

  Sep 23, 2015 12:03 PM

  26549 views | 4 replies

• 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

  12851 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

  8468 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

  18259 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

  12885 views | 5 replies