Data filter script
I am filtering data using values in a column. Is it possible to attach a script to the data filter so that the script runs whenever the a new column value is selected in the filter?Thanks.

Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI am filtering data using values in a column. Is it possible to attach a script to the data filter so that the script runs whenever the a new column value is selected in the filter?Thanks.
Hi all,I create a table through tabulate and each time it gets a name of "untitled xxx", however I would like to set a name for it for further reportings. The script is:(Data Table( "AnnualFinancial.jmp" ) << Tabulate( Remove Column Label( Grouping Columns( :Type ) ), Show Chart( 1 ), Show Control Panel( 0 ), Uniform plot scale( 0 ), Add Table( Column Table( Analysis Columns(...
I have a dataset with several samples and each sample has 10-30 measurements in separate rows. I want to be able to assign a random value from 1 to the number of measurements for each sample. I can use Col Shuffle to randomize but it requires subetting the data into several tables and applying a formula to each subset before updating the original table with the randomized numbers. Is there a metho...
Hello,I have a problem on my app create with the App Generator.I have created a window with an histogram, and an table (both on the same window). When i select rows in my table, my histogram is automaticly updated.But my problem is when I try to had a filter box on the same window :pDate <<launch( df = ds << Data Filter( Local, columns( Eval("File Date") ) );My data filter is launch, but when I tr...
Hi,I would like to use JMP to solve for y in an equation of the form y = f(y,x). A more precise equation is attached. This problem seem similar to that discussed in Numerical solver add-in, although a clear solution is not mentioned.In the attached equation, y is response, x is predictor, and a - k are fitting parameters.What is the best way for JMP to tackle this? I am using JMP11. Thanks!
/*I would like to control the decimal output for graph labels within JSL script.I need to set the number of decimal places displayed explicitly, as opposed to graph builder default.For Example: Increase decimal from 3 to 5.I have been unable to locate this control within Garph Builder Axis Settings or JMP Preferences.I assume the control command occurs within or just after the Label( "Value" ) c...
Hi All!I need to report 3 different structured data tables (budget, income, crm) in one report which urges me to call data from 3 different data tables. Is it possible?Let's say I need to make a formula ColSum of dt1,byvariable / ColMean dt2, byvarieble to beplaced at dt3 ?
brand new to jmp pro 11 and have a question after reading a bit of using jmp, discovering jmp, and ch 4 on cluster analysis from the book multivariate methods. i have a hierarchical dataset and am attempting to determine what each level's contribution is to the total variance. could someone please take a moment to get me started ? in great appreciation, jw
Hi,I'm a little bit confused by the explanation of "Relative Std Error of Estimate" in JMP documentationEvaluate Design WindowIt states that "The Relative Std Error of Estimate gives the ratio of the variance of a parameter’s estimate to the error standard deviation.", but looking at the formula given below that sentence it looks like to me that it should be "the ratio of the standard deviation of...
When analyzing trends in data (i.e. process monitoring) is there a way in JMP to analyze when exactly a shift started?Thank you,Agnès
Is there a way to control the formatting of the exported PowerPoint deck? The exported file needs so much clean up I am not sure if it saves any time over cutting and pasting. I made a simple journal from the big class data table and a 1 page journal turns into a 5 page PowerPoint. The resulting PowerPoint is attached.
A question came up regarding Point-Biserial correlation coefficient .. Here are the references that were cited. Here are the references:1. http://www.andrews.edu/~calkins/math/edrm611/edrm13.htm#POINTB)2. http://en.wikipedia.org/wiki/Point-biserial_correlation_coefficientI am interested in knowing how this can be done in JMP.ThanksPrakash
Hi, I have a question regarding the post-hoc t-tests in JMP. I run a repeated measures ANOVA with one random and two fixed factors. The two-way interaction between the fixed factors is included. (Y=random(A) + A + B + A*B). Following a significant A*B effect, I use the 'effect details' option to do post-hoc t-tests, Bonferroni-corrected for the number of comparisons. But. When I chose 'detailed co...
How can I change the group means line color in the Variability Chart Platform? There is not an option to do so in the chart's Customize menu. Thanks!
I have a data set and use tabulate to summarize the data and publish in the exportable interactive HTML form (implementing in a website where exporting to excel does not help).However I am unable to do it. The bottom tabulate takes the mean of several rows and I need as an aggregate the sum of those means which should be 827102,270 or vica versaI could add the sum of rows and I would need the mean...
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...
Presenter: Will Morgan, Associate Software Developer - JMP Join us for a Scripters Club...
Jump into Gauge Studies Date: Wednesday, October 15Time: 1:00 – 2:30 p.m. ETDuration...