456824_en-US

liliconcom

Data Filter Limit Selectable Items

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

GraphicsScriptingRe: Data Filter Limit Selectable Items

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

 

 

 

Re: Data Filter Limit Selectable Items

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?