Filter for showing when 3 bet very small/small stack to pot

[juvefan12]

Hello, I am looking to to create a filter for hands where Villain 3 bets short and with a very small stack to pot ratio. For instance villain has 20 or less BB and 3 bets my original open raise to between 3-5 BB. Thank you

[Flag_Hippo]

I am looking to to create a filter for hands where Villain 3 bets short and with a very small stack to pot ratio. For instance villain has 20 or less BB

If you want to filter based on a different players stack size then that's more complex and will require a subquery - for more on how SELECT works see here.

and 3 bets my original open raise to between 3-5 BB.

The following is true in this case:

Code: Select all

tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.amt_p_3bet_facing > 0 and ((tourney_hand_player_statistics.amt_p_raise_made + tourney_hand_player_statistics.amt_p_3bet_facing) / tourney_blinds.amt_bb) between 3 and 5

You can use this expression filter in a custom report by clicking on the 'Filters' link and selecting 'Add New Expression Filters' and you will need to replace "cash" with "tourney" if you are in a tournament report.