How to stack time series data when the data repeats with different units (double stack?)
In this case sales are first expressed in units and then dollars. This is a common output format from SAP. Starting file and left. Goal on the right.
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesIn this case sales are first expressed in units and then dollars. This is a common output format from SAP. Starting file and left. Goal on the right.
hi, I've wrote this jsl to rename cell with"portion" by "Portion".It's doesn't work.has someone a solution? Names Default To Here( 1 );dt= Current Data Table();For( I = 1, I <= N Rows( dt ), I++,if(dt:Format == "portion",dt:Format == "Portion" );); best regards
Hi All, I have been searching this topic throughout the community discussions but I had not luck so far. How to get the graph builder to dispatch a variable scale for the Y variable depending on the data range? Using the BigClass data example If I had more than one graph to plot I would use the following script:dt= Open ("Big Class.JMP");
win = New window("Graphs", lub = Lineup Box (Ncol(2)))...
I have the following JSL code where I call a MATLAB script, LTDmacroNew, and output a MATLAB structure, sensitivityResults. The MATLAB script saves a .mat file and generates some .png figures. JMP is connecting with MATLAB and doing all of that successfully, however it's only showing the first row of my structure. Here is the MATLAB structure with 12 fields/columns and 19 rows However, the JMP da...
so i want something like this:i'd prefer all the y-axis values to be on the same side and each y-axis is a seperate column of data and labeled seperately using the header of that column. the x-axis is categorical and the same for all panels. any ideas?
I have the following JSL code where I call a MATLAB script, LTDmacroNew, and output a MATLAB structure, sensitivityResults. The MATLAB script saves a .mat file and generates some .png figures. JMP is connecting with MATLAB and doing all of that successfully, however it's only showing the first row of my structure. Here is the MATLAB structure with 12 fields/columns and 19 rows However, the JMP da...
It seems an easy question but I'm struggling to solve it...I have this kind of data table : It goes until 64 which is the parameter "dim" in my script.I'm looking for the maximum and minimum of all median_range_mm 1, 2 , 3 ... until 64. But I don't want JMP to look at rows where target_status is different of 5 or 9.As you can see, when target status is 10 it overranges at 39996.It is easier to ...
Hi All This is a follow up on the post: https://community.jmp.com/t5/Discussions/JSL-How-to-close-data-tables-after-analysis/m-p/36739 However, I have encountered an error on my script while running JSL Debgger. DontClose = ("dt4"); // Example names of tables you want to leave
// Loop backwards through the list, so the table numbers do not change
For( i = N Table(), i >= 0, i--,
If( Contains( ...
Hi, Is there a way in JMP to label outliers in a dataset. For example, I have 100 lots and I want to label the units that are observered on the lower side of the distrubution. I dont care if the outliers perform better than the distrubution, I am more intersted in the lower ones. In other words for example, I have a lot with 100 units, 1 or 2 units are outliers. How can I label those units? Than...
what's the Marginal Model Plots use for ?how to explain it ?
I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch(
{},
"400",
ScaleBox,
{Legend Model(
8,...
Hello!
How do I get the mean separation letter in for each level of a factor when interaction is significant? For example, if I have A*B interaction and I want to get the mean separation of B at each level of A, how do I get the LSD letters in JMP? I can do test slices and that will use the DF of the full analysis, but this does not shows which mean of B differs. If I do multiple comparison: How ca...
Hi all,I need to perform the ANCOVA for a repeated-measures design. I tried to adapt the Julian's ANCOVA procedure showed on the https://www.youtube.com/watch?v=mApbp1RDy-U to my study case (repeated-measures design). Initially, I did the following actions: 1. In the Fit Y by X dialogue: I selected VAR_Y as "Y, Response" and VAR_X as "X, Factor";2. For "Group by" I selected the variable Timepoint;...
Hello Everyone, My question pertains to understanding what the terminology in JMP's prewhiten platform means.Also, understanding how that helps me determine an appropriate Transfer Function that I can use to test whether x causes y. JMP's prewhiten output shows three different ACF's labeled "Prewhiten Corr", "Noise AutoCorr", & "Noise Partial AutoCorr".
What is the Prewhiten Corr, Noise AutoCorr, &...
Hi all--having an issue. I am using Fit Y by X to fit 5,000 separate regressions. I hold control, select red drop-down arrow, and Fit->Flexible, Fit->Spline and select, say, 0.1. This fits a spline to all 5,000 graphs with lambda of 0.1. I have 28 X values in each of 5,000 graphs, and I understand there are 4 different spline coefficients (A, B, C, D). I understand if I just had 1 regression...
Una introducción práctica para nuevos usuarios, usuarios con licencia de prueba o cualquier persona...
JMP Live offers JMP users collaborative analytics software to share analyses from JMP to a secure, c...
French Mastering JMP Transformez des données brutes en informations exploitables grâce à l’éditeur d...
EMEA Mastering JMP Experimenting with microbial and mammalian systems brings a multitude of data; bi...