Advanced filters

In this article we get into some of the more advanced things you can do with filters. If you haven’t already read the article in this series on Filtering your data, go ahead and check it out first.

Saved filters

Saved filters are collections of one or more individual conditions that you can reuse across your visualizations and formulas. We use the term “condition” here to refer to individual filters within a saved filter to avoid confusion. You can add saved filters to an open visualization by searching them by name or by scrolling all the way to the bottom of the list of filters. Unlike the Filter Workspace, saved filters are not global and will only act on the visualization you’ve added it to. If you make edits to a saved filter and save your changes, it will update all the other instances where you’ve used that saved filter. Saved filters can be created outside of a visualization by selecting “Filters” after navigating to the Asset Manager section.

And/Or

One neat aspect of saved filters is you can choose between chaining together conditions with AND or an OR. By default, conditions in a saved filter use AND, but OR can also be used.

Example

For example you can view all the hands you “played” i.e. where you didn’t immediately fold, by adding a condition for VPIP AND a condition for Saw Round 1. Changing the filter operator to OR captures all the times you put money in the pot as well as the times when you were in the big blind and there were no pre-flop raises.

Opponent filters

If you scroll through the list of potential filters, you’ll notice a large number of “Opponent” filters. Use these filters when you want to filter on what an opponent did rather than what you did in the hand. For example, if you’re looking at Hand Browser and you set a filter for 3-Bet, it would return hands where you 3-Bet. On the other hand, if you used the Opponent 3-Bet filter it would show hands where another player 3-Bet. The Opponent Name filter is another useful filter allowing you to see results vs a particular player.

You can chain together as many opponent conditions as you’d like. Let’s say you created a new saved filter and added a condition on Opponent 3-Bet and another on Opponent position = BTN. This would filter on hands where just the button 3-Bet. If you added another condition, Opponent CBet Round 1, you'd get just the hands where the button 3bet and then continuation bet the flop. This chain of conditions is self-contained within a single saved filter. If you wanted to filter on what two different opponents were doing in the same hand you’d need to create another saved filter for the second opponent.

Aggregate filters

One thing you can’t do with a normal filter is create a condition based on number of hands played, or on a particular stat. That’s because these values aren’t fixed in the database and depend on how the data is grouped in your graph or report. You can however use the flags feature to create a filter in this way. From the presentation panel, click on the gear button next to the field you want to filter on. Switch on Flag/Hide Data, then select “Hide data that doesn’t match this condition”. You can then set a filter and the visualization will update automatically.