update: data is in a google sheet.
Security filter on a table. Which expression is more efficient, or does it matter?
LOOKUP(USEREMAIL(), “Users”, “USER_EMAIL”, "PI_NO”)>=15
My User[PI_NO]>=15
where slice My User only contains the current user’s info based on Row Filter: (USEREMAIL() = [USER_EMAIL])
Of course, this assumes that I wrote the expressions correctly.
User | Count |
---|---|
40 | |
36 | |
32 | |
23 | |
16 |