Hi, I’m using a variable filter [[AND {{user}}]] where user is pointing to a table “Users” column “Full name”, thing is each user has a Client ID and i would like to only show, on the dropdown, on my dashboard Users linked to a specific Client ID.
How can i achieve this? I’ve tried [[AND {{user}} where clientID = x]] and other approaches but than the filter stop working like a dropdown allowing text only.