Filtering an embedded Analytics dashboard in Creator
I have an Analytics dashboard that shows key stats by organisation(s), based off two main tables synced from Creator (projects and project members). Within Analytics, it works beautifully.
However, when embedding the report into Creator, I need to pre-filter to just the organisations that each user can access. But I can only get the filter to work on one of the tables. The code below filters against Project_Members but ignores the Projects filter.
Replacing the & with
%20and%20 causes the dashboard to error.
Has anyone embedded an Analytics dashboard filtered by two tables, who can give me a steer on the syntax please?