I think local data filter is able to show and hide values (not sure if this is true in every case) but it wont for example modify axis
Names Default To Here(1);
dt = open("$SAMPLE_DATA/Big Class.jmp");
nw = new window("myreport", gb = dt << Graph Builder(
Show Control Panel(0),
Variables(X(:weight), Y(:height), Overlay(:sex)),
Elements(Points(X, Y, Legend(9))),
Local Data Filter(
Show Modes(1),
Mode(Include(0)),
Add Filter(columns(:age), Display(:age, N Items(6)))
)
));
nw << Save Interactive HTML("$TEMP/filter.html");
wait(0);
nw << close window;
Close(dt, no save);
Web("$TEMP/filter.html");
I'm a bit puzzled about how you were able to get multiple local data filters to work. I think it may be just a matter of what we consider multiple local data filters.
A single local data filter can have multiple filters, like age and height for the sample above. This has been supported in Interactive HTML for several versions already. The multiple local data filter support in Interactive HTML for JMP 18 is for a report including multiple graphs and two or more of the graphs have their own local data filter. I didn't realize until now that you are only trying to filter one graph, so you have a single local data filter with multiple filters.
Depending on how these filters span the data, and what you have as your X and Y (what categories your mean points represent) the mean points may or may not hide as the filters change.
To see a simple example, replace the Graph Builder section in the script above with the following:
Graph Builder(
Size( 271, 266 ),
Show Control Panel( 0 ),
Variables( X( :sex ), Y( :weight ) ),
Elements( Points( X, Y, Legend( 2 ), Summary Statistic( "Mean" ) ) ),
Local Data Filter(
Show Modes( 1 ),
Mode( Include( 0 ) ),
Add Filter(
columns( :age ),
Display( :age, N Items( 6 ) )
)
)
);
Since the categories F and M include data from all ages, the mean points will show no matter what ages you choose to show with the local data filter. You may also notice that the mean points remain the same no matter what ages you choose to show. That is because the mean calculation is based on Included rows in each category and we are not excluding any rows with this local data filter.
If you were to remove or exclude the only 16 year old Male, the Mean point for the M category would change and be hidden only when you select (to show) age = 16 in the local data filter.
If you would like more help with your specific case, and don't feel comfortable sharing all the details here, please contact our technical support. With the specifics of your filter setup and your large data(anonymized if you wish) they may be able to figure out how to achieve your goals in JMP 17.2.
I hope this helps,
~John