Filter again specif opponent stat

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Filter again specif opponent stat

Postby 4StarGen » Sun Oct 15, 2017 2:47 pm

I want to know how I'm doing vs a 2% 3bettors, how can I do it?
4StarGen
 
Posts: 929
Joined: Sat Mar 08, 2014 6:58 am

Re: Filter again specif opponent stat

Postby Flag_Hippo » Mon Oct 16, 2017 6:53 am

You can filter a custom report to hands where a player with a specific 3Bet Preflop stat was dealt in with this expression filter:

Code: Select all
cash_hand_player_statistics.id_hand in (SELECT thps.id_hand from cash_hand_player_statistics thps, cash_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player HAVING ((((sum(tc.cnt_p_3bet) / (sum(tc.cnt_p_3bet_opp)))) between x and y)))

If you want to filter in more detail such as specifying that this player VPIP'd then a method for that is mentioned here.
Flag_Hippo
Moderator
 
Posts: 14507
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 25 guests

cron
highfalutin