topic Local data filter in application builder in Discussions

Local data filter in application builder

FN — Sat, 10 Jun 2023 23:37:49 GMT

I have an application that contains a 'Filter Col Selector' already.

The application asks the user for Xs, Ys, etc.

I would like to add the option of having a 'Local Data Filter' so the user can remove certain rows from Xs and Ys before running the script.

The option is deactivated on the menu bar and I see there is a 'Local data filter' within the App Builder.

Yet, when I try to add it, this is linked to another data table and I cannot hide it (or collapse it).

What am I missing?

Re: Local data filter in application builder

FN — Wed, 13 Oct 2021 16:48:27 GMT

For example, if I wanted to filter some rows using the add-in from @brady_brady before doing the analysis.

Re: Local data filter in application builder

danschikore — Wed, 13 Oct 2021 18:42:13 GMT

Hi @FN - I think the local data filter in the toolbar is greyed out in this case because the report is not a JMP platform.

I see that the app already has an option to "Omit excluded rows", which I assume is based on data table row states. Is it a requirement to use a Local Data Filter, or could you use the Global Data Filter to select the rows that you want to keep? If you switch to a Local Data Filter, the rest of the app logic that determines which rows to include will need to change a little.

Re: Local data filter in application builder

FN — Thu, 14 Oct 2021 13:30:15 GMT

I am after something that allows fewer steps. What's a global data filter?

Not using excluded rows is already part of my application, but it forces users to do the selection, exclude rows, use the application, go back to the table, and unexclude them again.

Re: Local data filter in application builder

Mark_Bailey — Thu, 14 Oct 2021 16:21:17 GMT

Select Rows > Data Filter. This tool interactively modifies the row states of the current data table. These changes are pushed to all open platforms. This behavior has been fundamental to using JMP since the 90s. The Data Filter was added to keep you in your workflow and not have to go back to the data table for each change. Then some users wanted to temporarily change row states within the platform, but not in the data table (leave them undisturbed and distinct).

Re: Local data filter in application builder

FN — Thu, 14 Oct 2021 18:45:30 GMT

Nice. It also seems accessible via JSL so I can add or remove columns to filter based on user selection.