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

Allow ReportBuilder to exclude a range of cells when adding filters for reports

Avatar

Avatar
Applaud 5
Level 1
jeampz
Level 1

Likes

0 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Applaud 5
View profile

Avatar
Applaud 5
Level 1
jeampz
Level 1

Likes

0 likes

Total Posts

15 posts

Correct reply

0 solutions
Top badges earned
Applaud 5
View profile
jeampz
Level 1

14-04-2015

Currently, ReportBuilder lets you specify a range of cells you would like to filter values of a report by. 

 

But sometimes I have a list of values I want, but I need a report to show me all values that are outside that list. This works as a catch-all request for values that you don't expect to show up in report. It is mainly for debugging, but good use case scenarios are to generate a list of erroneous tracking codes, or a list of Recommending Pages that for ome reason show that people have clicked on recommendations even though they have no recommendations. 

 

The current functionality to select a range is the one below, but I think adding an exclude option will make life easier.

 

RB_Exclude_range_of_cells.png