Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

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

Avatar

Level 10

3/22/21

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