Welcome to the JMP User Community!

Latest Discussions

• trailing cumulative sum formula

  I have what is likely to be a very easy formula need. I have a temperature dataset and need to calculate a trailing cumulative sum over the past 120 days (known as "degree-heating weeks" since I will convert this sum to weeks by dividing by 7). I know how to get a trailing average, and I know how to get a cumulative sum, but is it possible to get a trailing, 120-day cumulative sum? In this case, w...

  abmayfield

  Discussions |

  Dec 15, 2020 2:53 PM

  5496 views | 11 replies

• Is there a script to ensure my mark by colour in variability chart stays fixed?

  I created a JSL script to automatically plot a variability chart in JMP and made the row legend to adjust my specific column into a specific colour (Chart in control flag). Unfortunately it did not captured the entire script when I used copy script feature in JMP. I've shared a picture with example below. The colour should be blue (Y) and red (N). It seemed like there's a problem with the chart in...

  Danial1

  Discussions |

  Dec 15, 2020 11:15 AM

  2841 views | 4 replies

• Where do I find odds ratios for a binomial logit generalised linear model?

  Hello,I am trying to run a binomial logit generalised linear model and am having some difficulties finding where the odds ratio and p-values are. My independent and dependent variables are both binary (yes/no). I am trying to run an unadjusted model first, and then re-running the model but adjusting for 2 confounders. However, when I run the model, there is no option to open odds ratios under the ...

  XH

  Discussions |

  Dec 15, 2020 3:18 AM

  3112 views | 5 replies

• Like COALESCE function in JSL

  I have been looking for the function with which we could have an alternative value(e.g. A) if the column X is null, like COALESCE function, and the equation could be something like: COALESCE(:X, A) if X is not null, then it return the value of X if X is null, then it return the value A   I understood that we manage to have such results by having a bit complicated equation, but I was wondering if w...

  WakuWakuGoku

  Discussions |

  Dec 14, 2020 5:01 PM

  1970 views | 2 replies

• Pass argument when running script from command line

  I have a JMP script that runs as a part of a larger script written in PowerShell.I start the JMP script using Start-Process -FilePath $JMP_path -ArgumentList ("`""+$JMPScriptPath+"`"") -WaitI'd like to pass an additional argument to a script - just a text string.How do I do that?I tried just writing it into an Environmental variable, but while JMP can read it just fine when it runs as a standalone...

  miguello

  Discussions |

  Dec 14, 2020 1:48 PM

  4080 views | 6 replies