The Automatic Recalc is not selected, but the chart changes with the row filter.
Is this deliberate, if so, how may it be disabled please?
Autorecalc controls the recalculation of statistics and calculated elements displayed on a graph, but display single value elements(row values) will appear and go away when the "Show" value is selected in the data filter. Notice, in your screen display, that the statistical values in the Summary of Fit display table do not change, just the displayed single data points.
Why does only the Bivariate chart change and not others?
Using automation to generate many charts, each based on a filter, I'd like the charts to stay as they were when generated, as the variability chart does
Data Filters can be added either globally or locally to each platform and associated reports. However, sometimes we may not know where and when to filter. Here's a video that explains the difference and a variety of applications in JMP. Hope this helps.
In your data filter you have Show and Include checked. That causes all the points that are not part of your selection to excluded and hidden. If you want those points to still be shown no matter your choice(s) you will need to uncheck those boxes. The points that are not part of the selection will be grayed and points of choice will be darker(color dependent)
I am sorry, I am not communicating.
Both charts are created from the same data set. The Mean is a column of numbers, nothing is calculated
The first image one item from each filter is selected and the charts generated.
In the second image, an addition item was selected from the filter. The additional data is added to the Bivariate chart, but not the Variability chart.
In the third image, a different item is added to the filter and the added data points do not appear on either chart.
In the forth imahe, Autorecalc was selected on the Variability chart and the additional data appears on it.
The Bivariate chart appears to act differently than the Variability chart when the filter is changed.
I am running an automation script I created that generates many charts based on selected filter items.
The fifth image is the result of running the script. It generated one Variability chart for each filter item "ROI" The charts do not change after the filter is clearedd from the data table. This is the behavior I was expecting from the Bivariate chart, but when the filter is cleared the Bivariate chart plots all data.
The sixth image is a Bivariate chart after the filter is cleared.
The real question is why does the Bivariate chart act differently from the variability chart
Here is my guess as to what you are seeing. You are running the Bivariate. You then open a data filter and make some selections. You then run the Variability Chart. You then go back to the filter and make changes. You see the changes in the Bivariate display, but not in the Variability display.
The explanation:
The Bivariate chart is not calculating anything, and therefore it's display is changing as you change the filter.
The Variability chart was generated with a filter turned on. The Variability chart is a calculated environment, not just a display environment. So the categories on the X axis were determined during a filtered situation. When you change the filter, if new raw data are now available to the Variability chart, the chart does not know what to do with the data, since the parameters of the chart were determined without those data points.
Below is a simple script that illustrates the situation. Once the bivariate runs and the variability chart comes up, go to the data filter and select "clear" what you will see is that even though more data values appear on the bivariate chart, the variability chart does not know how to handle the new points. Now go to the data filter and select the Males. All data points on the variability chart go away, but only half of the values on the bivariate chart.
dt=open("$SAMPLE_DATA/big class.jmp"); Oneway( Y( :height ), X( :age ) ); wait(0); dt << Data Filter( Location( {635, 44} ), Mode( Show( 1 ), Include( 1 ) ), Add Filter( columns( :sex ), Where( :sex == "F" ) ) ); wait(5); dt <<Variability Chart( Y( :height ), X( :age ), Max Iter( 100 ), Conv Limit( 0.00000001 ), Number Integration Abscissas( 128 ), Number Function Evals( 65536 ), Analysis Type( "Choose best analysis (EMS REML Bayesian)" ), Show Range Bars( 0 ), Show Separators( 0 ), Std Dev Chart( 1 ), SendToReport( Dispatch( {"Variability Chart for height"}, "Variability Chart", FrameBox, {Grid Line Order( 2 ), Reference Line Order( 3 )} ) ) );
I'm not sure if this will get me where I need to be.
The chart generation is automated, creating many charts each based on a unique filter. In the end, each chart should remain as it appeared when the filter that created it was applied, but Bivariate charts change when the filter changes.
Another individual indicated this is because variability charts are calculating and thus do not change, but bivariate charts are non-calculating and this is why they change.
Is there a method to stop charts from updating when the filter changes?
A Local Data Filter will absolutely get you where you need to be. The Global Data Filter will affect all reports using the data table in question. The Local Data Filter affects only the report that it's a part of.
Here's a script that shows the technique.
dt=open("$SAMPLE_DATA\Variability Data\2 Factors Crossed.jmp"); dt<<Bivariate( Y( :Measurement ), X( :Standard ), Automatic Recalc( 1 ), Fit Line( {Line Color( {208, 64, 86} )} ), Local Data Filter( Close Outline( 1 ), Add Filter( columns( :part# ), Where( :part# == {2, 4, 6, 7, 10} ), Display( :part#, Size( 149, 140 ), List Display ) ) ) ); dt<<Variability Chart( Y( :Measurement ), X( :part# ), Max Iter( 100 ), Conv Limit( 0.00000001 ), Number Integration Abscissas( 128 ), Number Function Evals( 65536 ), Analysis Type( "Choose best analysis (EMS REML Bayesian)" ), Show Range Bars( 0 ), Std Dev Chart( 1 ), Automatic Recalc( 1 ), Local Data Filter( Add Filter( columns( :part# ), Where( :part# == {1, 3, 5, 8} ), Display( :part#, Size( 149, 140 ), List Display ) ) ), SendToReport( Dispatch( {"Variability Chart for Measurement"}, "Variability Chart", FrameBox, {Grid Line Order( 2 ), Reference Line Order( 3 )} ) ) );
Do you need to use a data filter at all? You can manipulate row states directly with your script before creating the next plot. You may have another reason but if it is just to select, hide/unhide, or exclude/unexclude rows, you don't need a data filter. I think the only reason to open the data filter if the script must have the user interactively make changes to the row state with this tool. Otherwise the automation can handle it on its own.
(I am not answering the questions about the behavior of the data filter. Just trying to get you to your end point sooner.)
Thank you for your help.
I responded to txnelson and explained what I am doing. I thought filtering the data (by automation) was the best way to create charts showing only the desired data set. If there is a better way, I am unaware of what it is.
I like this application that really support presentation about pandemic and endemic outbreak.
