Hi all, I have a user setting turned on with two ENUM options for different branches (see below). What I want my Slice to do is show either 1) all the Nelson rows when Nelson is selected, b) all the Wellington rows when Wellington is selected, or c) all the rows, unfiltered, when neither option is selected (or if it works better I could create a third option called All). Is there a filter expression that can do this?
1 Like
Please try a slice filter expression something like below when all branches need to be shown when neither option is selected
IF(ISBLANK(USERSETTINGS(Branch)), TRUE, USERSETTINGS(Branch)=[Branch])
[Branch] is the “Branch” column in the table.
Please use expression something like below, when you have third enum option of “All”
IF(USERSETTINGS(Branch)=“All”, TRUE, USERSETTINGS(Branch)=[Branch])
2 Likes
Thank you!
2 Likes