I have run into the same issue. Once a field is added in the ‘Fields (optional)’ section, only that field will display in the report. I found that I need to add every field I want to display in the report in the ‘Fields (optional)’ section whether that field is a filterable field or not. The problem now is that I cannot filter on a field. Checking ‘Yes’ on ‘Filterable (optional)’ in Advanced Field Options does not appear to have any effect. How do you apply a filter to a report? Does it have anything to do with what’s written below, and if so, how does this work?
Available Variables: %%WHERE%% %%HAVING%% %%ORDERBY%% %%LIMIT%%
(example: WHERE %%WHERE%% my_field=1)
