Iโve created a slice with a formula that I am confident works because I when I click โview dataโ I see the rows I want displayed. However, when I try to select the slice as the source in UX (for a deck, table, map, etc.) it returns no values. I donโt believe the UX view to be an issue because if I change the source to my table instead of a slice, it populates as expected. Iโve played with it for a long time, but suspect there is some simple thing I am overlooking. Does this sound familiar to anyone? Suggestions? TIA!
Solved! Go to Solution.
When using FIND() expression, the resut is number, not TRUE/FALSE. You would need to use something likeโฆ FIND(โCharlotteโ, [Categories])>0
Indeed, there are a few formulas that donโt evaluate the same way depending on where itโs run. The expression builder and the app evaluate formulas using different mechanisms, so sometimes things donโt work out as you planned.
What is the formula for your slice, usually itโs just a matter of switching around some logic.
Thank you, that is encouraging to hear. The formula Iโm using is:
True = FIND(โCharlotteโ, [Categories])
@rwksys May I ask what is your formula?
True = FIND(โCharlotteโ, [Categories])
Thanks, the formula that seems to work in preview but not in UX is intended to include only items where the keyword โCharlotteโ is included in the category field (which is a text filed that may contain more than just the word Charlotte so I want any that includes Charlotte in the value):
True = FIND(โCharlotteโ, [Categories])
When using FIND() expression, the resut is number, not TRUE/FALSE. You would need to use something likeโฆ FIND(โCharlotteโ, [Categories])>0
That did it! Thank you so much!
Youโre welcome
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |