After hours or trying / researching I turn to you all for help with this apparently simple (yet - for me - elusive) Slice problem.
in the USER SETTINGS I have:
Track (text) which can be A, B, C etc
Activity (text) which can be Riffles, Archery, Rafting etc
in table SESSION_LIST I have:
session_uid (text) set UNIQUE()
track (text) as above
activity (text) as above
done (Yes/No)
I want to create a single View, using a Slice of SESSION_LIST that will EITHER
a. list matching rows by track - ie [_THISUSER].[Track] = [track]
OR
b. list matching rows activity - ie [_THISUSER].[Activity] = [activity]
Despite trying multiple way of creating the Slice, it is either empty or shows everything in SESSION_LIST. I've tried SELECT, IF, SWITCH, virtual columns ... and now find myself so confused I don't know which way is up.
Guidance, suggestions, other solutions very welcome.
LinkedIn
Twitter
