Select to view content in your preferred language

Can't find values that I need to filter for (Arcade the culprit)?

2190
11
09-29-2022 08:38 AM
RandyMcGregor3
Frequent Contributor

I have worked around this problem and don't have examples to present, but it could be a problem down the road and am concerned.

I have a dataset with about 70 unique values and need to filter - in a dashboard list using a data expression - for 6 values.

In the dropdown, 2 of the values I need are not available and I cannot type them in - 'Value Not Found'

If I do not filter, I can see the 2 values I need. THEY ARE IN THERE (Pardon the all caps). 

The workaround is that I did a definition query in ArcPro on the 6 values I need and put no filter in the dashboard. That works (for now).

Is this some known limit with Arcade data expressions? The filter is NOT seeing some values that are in the dataset.

Thank you,

Randy McGregor

0 Kudos
11 Replies
RhettZufelt
MVP Notable Contributor

No idea if this applies, but I had this issue when one of my drop down lists had numeric values.  No matter where I "formatted" it, there were still commas showing up in the values in the drop down list.  So, when I type 3295 in the list,  'Value Not Found'......  For some reason, scrolling down the list won't show them either.

However, if I typed 3,295 it finds it just fine.  Did not figure out a way around this yet.

R_

0 Kudos
RandyMcGregor3
Frequent Contributor

Oh boy. It's working today. I published the layer unfiltered and was able to filter it as I needed within the dashboard. Obviously, there was some technical glitch in the system, maybe some mistake I made, but it's working fine now. 

Thank you to all who responded. I appreciate it!

0 Kudos