Tabulate
Bonjour, est-ce qu'on peut remplacer les zéros dans un tableau par un espace (= pas de valeurs) pour mieux voir les données différentes de zéro?peut-on le faire avec le script du tableau? cordialement
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI am trying to write a script to sum specific columns if they are present in the data table. Lets call them Col A, Col B, Col C, Col D. The problem is the data table does not always have all four columns which results in an error. I would like to write a script that can add Col A, Col B, Col C, and Col D that are present in the data table. Obviously I could just update the code for the ones presen...
Hello JMP Community,
I would like to add a unit of measure as an additional information in my graph.This is what i could create, painted in there is a possible solution I would like to have. Thanks for a hint how this could be done!Have a great weekend everybody!Ben What I also tried:
Label by value for the right part: here JMP takes the value which the bars are colored by. But this is a different ...
Hello JMP community, I would like to have vertical graph like on the left side. This graph is based on a data set far bigger. See on the right.Now I would only like to show the top 10 or top 5. Does anybody have a good idea for that? Ben What I tried so far, somehow works but not as I would intend it to: Generally that is possible by:Limiting with a local data filter for x so that the graph on the...
Bonjour à tous, j’ai une colonne « Date » dans ma base de données, j’ai déjà modifié le format que je souhaite. Juste un problème, lorsque j’effectue différentes opérations c’est comme si l’affichage du format de date est correcte visuellement (celui que j’ai modifié), mais l’ancien format de date reste actif et empêche les différentes manipulations. Plus précisément, je souhaite calculer des moye...
I am trying to write a script to sum specific columns if they are present in the data table. Lets call them Col A, Col B, Col C, Col D. The problem is the data table does not always have all four columns which results in an error. I would like to write a script that can add Col A, Col B, Col C, and Col D that are present in the data table. Obviously I could just update the code for the ones presen...
Hello JMP community, I would like to have vertical graph like on the left side. This graph is based on a data set far bigger. See on the right.Now I would only like to show the top 10 or top 5. Does anybody have a good idea for that? Ben What I tried so far, somehow works but not as I would intend it to: Generally that is possible by:Limiting with a local data filter for x so that the graph on the...
Hello everyone, I am using tabulate to massage data to exemplify yields and failures of machines. Generally the data is sorted by date (as Rows), and status (columns). I wanted to group this info by machines, as shown below. A - accept ; R - reject I would like to display this as percentages. i.e. yield of the machine per day. The Row % on tabulate is usually what I would use. In this case, it w...
I am trying to write a jsl to plot a bivariate plot between x vs. y, group by the values in column 'b' and fit a line through each of the groups (from the unique values in column 'b'). The script generated from the manual bivariate plot I did is as follows but I cannot figure out how to do add a for loop for all the "Fit Where" commands that go through the unique values in column 'b'Bivariate(
Y(
...
I am looking for an example of how to connect to oracle data with JMP 16 via oci. I have seen notes indicating that it is a far faster connection.
Bonjour à tous,Est-il possible de mettre dans le criblage des processus le format/la colonne de notre choix dans le module « dernière alarme ». Pour ma part j’aimerais pouvoir y mettre une colonne Date pour pouvoir contrôler à quels jour interviennent mes dernières alarmes.Merci pour votre aide.
I'm looking at the impact of 4 two level independent categorical variables on a continous dependent variable. How to I choose what effect to use for a posthoc analysis? If I choose forexample size*treatment*shelfcode how do I consider the effect color to explain dependent variable Firmness?Do I do posthoc on all interactions? If yes, how do I interprete separate posthocs on the same variable firmn...
The largest purchaser of care of the WorldBest Healthcare System complained that the average C-section rate at WorldBest had increased from 1999 to 2000 and was now over 21 percent. The average at other area hospitals was between 17 to 19 percent. To investigate the situation, WorldBest wants to set up a control chart to monitor the number of C-Sections every month. 1. What type of control chart s...
I'm working with a large dataset with a single continuous number column and then multiple nominal columns. I need to understand the % delta (or % difference) in the number column as a result of toggles in the nominal columns.With the Fit Y by X platform, I can readily add a function to provide the raw difference (as with the t test function), but I can find nothing for the % delta I'm needing. And...
A practical introduction for new users, trial users, and anyone who needs a refresher Registe...
Do you face challenges with restrictive data formats from EDS, XRD, or Raman instruments? Are the ex...
REGISTER HERE If you teach with JMP Student Edition, you should be aware of some lesser known...
Do you want to efficiently and interactively explore data to uncover patterns and see relationships...