Hello-
I am currently trying to filter a dataset by using an expression in Dashboards. The expression does more than just this filter so I cannot use the handy dandy filter tool within elements.
What I want my expression to say is Filter(dataset, feature 'contains the text' "State").
It seems fairly simple but I am having a hard time figuring this out. I tried following some of the suggestions from jcarlson in this post:
Solved: Arcade Expression for field "includes" a value - Esri Community
However, I am not really sure how to integrate this Split + Includes or the Find workflow into my filter function.
Here is a more Specific Code:
// Filter the FeatureSet for "State Trust" in the FUNDING_SOURCE field using Includes
var statelands = Filter(fs, Includes('FUNDING_SOURCE', 'State Trust'))
TIA!
Solved! Go to Solution.
You can use the "Like" operator in the sql statement
filter(fs, "FUNDING_SOURCE Like '%State%'")
You can use the "Like" operator in the sql statement
filter(fs, "FUNDING_SOURCE Like '%State%'")
YES! Thank you so much!