Welcome to the JMP User Community!

Latest Discussions

• GLM / Poisson with Overdispersion // use of AICc

  Hello. I have encountered the following issue while modeling with GLM/Poisson the data in the attached table (Response = Count, Regressor = X). Data visual exploration suggests a clear relationship between X and Count, but comparison of AICc for model with X vs null model favors the Null model (just intercept).  Scripts to reproduce the two models are embedded. I believe I have found an explanatio...

  matteo_patelmo

  Discussions |

  Nov 11, 2022 9:59 PM

  2768 views | 6 replies

• Excluding data from Graph Based on Value

  Is there a way to graph data, if it occurs 2 or more times? 
  
  For instance: 
  Column 1: Family Name
  Column 2: Rooms of the House with a Television in it
  
  Is there a way for me to sort and graph my data to only include families with 2 or more Televisions? 

  ClusteredTable4

  Discussions |

  Nov 11, 2022 6:07 PM

  1531 views | 3 replies

• Opening a specific date range from SQL tables

  I open a lot of tables from SQL and I would like to be able to open just the previous 7 days. So when I run the script I want it to look at the date/time column on the sql table and open only the data for the previous 7 days.  Here is my open table script:
  Open Database(
  "DSN=0.20;UID=****=****;APP=JMP;WSID=VJDSTATION;DATABASE=BioControl;",
  "SELECT * FROM dbo.VisitLog", "VisitLog"
  ); The column I want...

  JocelynJohnson

  Discussions |

  Nov 11, 2022 1:29 PM

  1552 views | 1 replies

• Regex Issure with Decimals and Whole Numbers

  Hello! Using JMP 16.2: I have a column with whole numbers and decimal numbers. I want to create a new column that flags the whole numbers (or the decimals).  Column Name: ValueColumn Inputs:0.533.76810etc. I have tried several versions of the following Regex using a column formula:Regex(Value,"\d+\,\d+", "Decimal")Regex(Char(Value),"\d+\,\d+", "Decimal")I have also tried parentheses and brackets t...

  Maerawlings

  Discussions |

  Nov 11, 2022 10:11 AM

  2239 views | 3 replies

• How to add the date to file name while uploading a file to s3 bucket using alteryx

  I have a workflow in alteryx where I am downloading two files from two different urls. After making the required modifications I want to upload them to the s3 bucket as well as save a copy locally. I want to add the current date while saving the file in both cases. I was successful in using a formula tool to rename the file saved locally. But unable to do for the copy being uploaded to s3. Can any...

  pavanroast

  Discussions |

  Nov 11, 2022 3:03 AM

  1029 views | 1 replies