Filter hands and ignore other player stack

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny

Filter hands and ignore other player stack

Postby jalba » Mon May 31, 2021 2:50 pm

I created a custom report where given 3 players, I want to filter hands for a certain stack size range between BTN and SB (e.g. 20-25BB), while ignoring BB. Effective stack stat works only if BB stack <= min(BTN, SB stack), but it doesn't if BB stack is larger than any of these two. Any way to get around this?
jalba
 
Posts: 14
Joined: Sat Aug 29, 2015 6:45 pm

Re: Filter hands and ignore other player stack

Postby Flag_Hippo » Tue Jun 01, 2021 6:08 am

That would need a custom expression filter in a custom report with a subquery that tests for the actual stacks of each player:

Code: Select all
tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, player p, tourney_blinds tb where thps.id_player = p.id_player and thps.id_blinds = tb.id_blinds and thps.position = 0 and (thps.amt_before / tb.amt_bb ) between 20 and 25) and tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, player p, tourney_blinds tb where thps.id_player = p.id_player and thps.id_blinds = tb.id_blinds and thps.position = 9 and (thps.amt_before / tb.amt_bb ) between 20 and 25)

You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'.
Flag_Hippo
Moderator
 
Posts: 10926
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 5 guests

cron