topic Re: Data Filter Limit Selectable Items in Discussions

Data Filter Limit Selectable Items without Excluding Rows

Martin — Sun, 11 Jun 2023 11:21:19 GMT

In JSL, is there a way to only show certain items from a particular column? For instance, say I have a data table with a column called "Color". That column of data is filled with "Blue", "Yellow", "Red", "Orange" values. I want to show a Local Data Filter where the only options for the user are "Yellow" and "Red" (meaning the user of the dashboard would not even know that "Blue" and "Orange" were in the data table.

Thanks in advance!

Martin

Re: Data Filter Limit Selectable Items

jthi — Fri, 28 Jan 2022 16:27:41 GMT

Could you exclude blue and orange rows? If you can then you could maybe disable Count Excluded Rows:

Re: Data Filter Limit Selectable Items

Martin — Fri, 28 Jan 2022 16:33:31 GMT

That is an obvious option, but no. This is part of a larger dashboard with many graphs/tables connected to the same data table. As such, I cannot exclude records from the table.

I would think that within the "df = dt < Local Data Filter( xxxx )" that there might be a way to only show specific values or levels for a particular field.

Any other options?

Re: Data Filter Limit Selectable Items

jthi — Fri, 28 Jan 2022 17:24:16 GMT

I'm not sure if it would be possible by using unstructured text and then hiding the search field, using "reverse" find with new column with some value you want to hide and then hide the search field or by building custom filter with for example List Box or by using Data Filter Context Box/Data Filter Source Box.