Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?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?
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?I like this application that really support presentation about pandemic and endemic outbreak.
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?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.
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?I created a GUI driven app that mimics a combination of the row filter and variability chart generation in JMP.
Pushing the preview button generates the variability charts based on the selections. Each chart displays the data as it was filtered when the chart was created.
I then had a need to do the same thing for Bivariate charts, which is what started my question. I added the same functionality, but for the Bivariate chart, but it doesn't act the same and after the charts are generated, each chart shows all of the data, unfiltered.
When I run the same code, just replace the variability chart with the bivariate chart, I expected this.
But get this
I have sinced learned this has to do with a chart being calculating or non-calculating. I would like to be able to automate more chart generation using any chart type
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?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.)
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?I am not quite sure what the desired final functionallity is? I am not sure if turning the Autorecalc on for the charts would get you what you want, or using local data filters or a combination of both, or maybe subsetting the data table for different groupings of charts. If you could describe what your final vision is I might be able to suggest a solution.
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?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></BIVARIATE>Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?I did see his post, can a local filter be achieved by automation?
I don't see anything in the object model
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?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?
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?Check out the post from @ryandewitt above and use a Local Data Filter for each of your reports.
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?Thank you. I believe the key is as you stated, is the difference between a calculating and non-calculating chart or environment. I have automated distribution generation also and it works like variability, which would seem consistant.
Is there a way to stop this behavior? The automation process generates many charts, each based on a unique filter, but this is defeated if they all look the same in the end.
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?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=""></VARIABILITY>Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?The real question is why does the Bivariate chart act differently from the variability chart
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?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.
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?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)
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?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.
- Data Filter: Every JMP report using that Data Table is filtered.
- Local Data Filter: Exclusive filtering in that platform or report.
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?The key to this is the statement from my original response.....and it is a fine point, so I can understand why you didn't pick up on it
"Autorecalc controls the recalculation of statistics and calculated elements displayed on a graph"
What is displayed in the Variability chart is a "Mean". A "Mean" has to be calculated. So if Autorecalc isn't turned on, the displayed "Mean" will not be recalculated.Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this please?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
Re: Bivariate Chart changes even if Automatic Recalc is not selected, how to stop this 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.
