Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Promt vs filter on a report

Avatar

Level 3

If i setup a report and say have in my filter - to filter by channel web, email, social

If i also set that as a prompt and on the prompt i just select web, does it overwrite the report filters with the prompt selection, or have i got to make sure what i set as a prompt isn't in the report filters

Many thanks

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 9
Level 9

Hi Dan.

If you set a filter in the report, and also make it a prompted report, the prompts will only refine the results that would otherwise be returned in the report.

E.g. I make a project filter that is "entry date = this year", and I add a prompt to the report for project status.

If I make no selections in the prompt when running the report, I'll get every project opened this year.

If I select "Active" in the prompt, I will only get projects that are in Active status AND were opened this year.

There is no way to use prompts to overwrite the filters that are set at the report level.