I’ve got a dashboard with 2 views: Map of Displays and Campaigns (interactive). I’m trying to limit which rows the user can see based on their state. I’ve got a table with a all the users and a column designating their state plus another column tagging them as either a “M” manager or “A” all.
I want the users tagged “A” to see all of the rows on the map. I want the users tagged “M” to only see the rows in the state they are listed in. What’s the best way to accomplish this? I have about 7 states so not keen on having 7 slices.