Filter vs 3bet + caller ?

[dolphinX]

hi

I need a filter for Vs 3bet situations + caller
https://i.gyazo.com/404656a0ffd008048aaad2e204198a1a.png


any idea ?


regards

[Flag_Hippo]

That isn't possible with built-in filters and would require a custom expression filter in 'My Reports'. I've built this example for you to try:

Code: Select all

cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_open_opp AND NOT cash_hand_player_statistics.position = 9 AND char_length(cash_hand_summary.str_aggressors_p) >= 3 AND char_length(cash_hand_summary.str_actors_p) >= 3 AND substring(cash_hand_summary.str_aggressors_p from 3 for 1) < substring(cash_hand_summary.str_aggressors_p from 2 for 1) AND substring(cash_hand_summary.str_actors_p from 3 for 1) SIMILAR TO '(8|9)' AND substring(cash_hand_summary.str_aggressors_p from 4 for 1) NOT SIMILAR TO '(8|9)'

This should filter for hands where you raised first in, a player in position 3bet and one or more players in the blinds call. You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. If you want to see other possible situations (e.g. an early position limper calls the 3bet or SB 3bets and BB calls e.t.c) then that will need a more complex filter or filtering for separately. This post has information on how the actors and aggressors strings work while this thread and this thread discuss how you can compare/test the strings.

[dolphinX]

Hi

I want a filter to see hands where I 3-bet and call a direct push.

regards

[Flag_Hippo]

This will cover hands with no cold callers/limpers but if you want to include those hands that's more complex and you would need to test the actors/aggressors strings in more detail (and/or use a subquery for the 4bettor):

Code: Select all

cash_hand_player_statistics.flg_p_3bet AND char_length(cash_hand_summary.str_aggressors_p) = 4 AND char_length(cash_hand_summary.str_actors_p) = 4 AND substring(cash_hand_summary.str_aggressors_p from 2 for 1) != substring(cash_hand_summary.str_aggressors_p from 4 for 1) AND lookup_actions_p.action = 'RC' and lookup_actions_f.action = ''