Stack of 3Bet player

[corvet]

Is it possible to filter the stack of the player who 3bet the hero ?
For ex I need hands when Hero RFI with 30-40bbs and faced 3bet NAI from 30-40bbs stack ?

[Flag_Hippo]

To filter the stack of a player who is not the active player will require a subquery:

Code: Select all

cash_hand_player_statistics.id_hand in (select chps.id_hand from cash_hand_player_statistics chps, cash_limit cl where chps.id_limit = cl.id_limit and chps.flg_p_3bet and (chps.amt_before / cl.amt_bb) between 30 and 40)

You can use this expression filter by clicking on the 'Filters' link in a custom report and selecting 'Add New Expression Filters'. For more on how SELECT works see here.

[corvet]

can you please clarify for tournaments, thank you so much

[Flag_Hippo]

Code: Select all

tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, tourney_blinds tb where thps.id_blinds = tb.id_blinds and thps.flg_p_3bet and (thps.amt_before / tb.amt_bb) between 30 and 40)