I’m creating individual reports. Each participant will only get access to their report. I get data from the users through 3 different surveys. I have to create several charts per user. I want to have 1 filter field (or look up value) that all other charts are linked to. Right now I’m creating the following:
- Table with emails pulled from survey 1 (table name is restory user). This is manually filtered to only show 1 email. By this I mean I set up a filter as in selectuser contains firstname.lastname@example.org
- Table with results from survey 2 for the selected users (table name is dcheckpoint). I can’t seem to get it done. Ideally it should be Table2[email in Table 2 = selected user in Table1)
When I manually create the filter, Table 2 is correctly filtered.
I’ve tried to filter Table by adding this formula:
Filter(dcheckpoint,Email = [Restory User].selectuser.First())
but that didn’t work.
Any ideas where I’m approaching this task wrong?