UI builder choice filter are missing values from table

[Nikolaj2]

Hi,

I have a question related to Dynamic filtering on dashboards in workspace. I have set up a graph in UI Builder and attached various filters to it.

However, i have an issue with filters that come from the choice table. Once i set up my filter it shows that it has 663 values available but when i check the same setup in the backend i have 1801 values:


When i open up the "Configure values" in UI builder i have anoter set of values, it does not show all 663 values.

In my specific case i am missing the values i need in UIB. And if i try to search for them to add them as default values, they do not appear.

Have anyone experienced similar issues and have found a solution that can help display all available values in the UIB?

An alternative option in my case could be using check boxes as filters, however i can not seem to figure out a way to make that work. 

Any help would be greatly appreciated.

UIB setup:

Same setup in chhoice table

[Brad Tilton]

First off, just more architecture guidance, a choice field with that many choices is ripe to converted to a reference field/table. I think the rule of thumb with choice fields is generally no more that 20ish.

For this specific issue, I would make sure all of those 1801 values are on the table you're looking at. On the platform side of things it will show you all of the choices for a field and they can exist on extended and base tables. I don't think the filter component has a limit but you might check that as well.

[Nikolaj2]

Hi Brad,

I will definitely investigate changing to a reference field, this could potentially solve the issue, however alot of things are using the current choice filed setup so it will not be an easy process.

The interesting thing is that the tabel im looking in to in this case only has two choices and thoes are available from the list when setting up the filter. Not sure why the UI Builder seems to ignore alot of the values and even the tabel i have selected.