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

Create a Search Filter in One Click (right click, context menu, freeform table)

Avatar

Avatar
Coach
Community Advisor
Andrey_Osadchuk
Community Advisor

Likes

557 likes

Total Posts

1,023 posts

Correct reply

273 solutions
Top badges earned
Coach
Originator
Shape 25
Bedrock
Boost 500
View profile

Avatar
Coach
Community Advisor
Andrey_Osadchuk
Community Advisor

Likes

557 likes

Total Posts

1,023 posts

Correct reply

273 solutions
Top badges earned
Coach
Originator
Shape 25
Bedrock
Boost 500
View profile
Andrey_Osadchuk
Community Advisor

22-03-2021

It is quite often when one or few line items have to be filtered off from the table. Creating a search filter manually takes time. It will a great time saver if it is possible to create a filter by selecting the line items, right click and add them to the filter as the search criteria.

 

Scenario 1: There are 35 dimension items in the table and only few of them should be filtered off. The user selects those few lines, right click and selects add to filter as exclude that creates a filter "does not equal X AND does not equal Y AND etc."

 

Scenario 2: There are 35 dimension items in the table  and only 9 should be displayed for the report/ analysis. The user selects those lines, right click and selects add to filter as include that creates a filter "equals X AND equal Y AND etc."

 

add to filter.png