Using the Filter tab, I've added a filter for a custom user profile field: School. In the summary for the filter, it says, "profile_school"
What code can I put in the SQL to reference the filter?
%%FILTER_USERS:u.profile_school%% doesn't work. I select a school from the dropdown on View Report and nothing happens.
I've also tried %%FILTER_USERS:prefix_user_data_info.data%% with the same results. Can anyone help?
Kimber