Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by kraada » Fri Sep 05, 2014 3:49 pm
Try these:
cnt_p_3bet_30_max:
sum(if[tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_player_statistics.amt_p_2bet_facing <= tourney_hand_player_statistics.amt_p_effective_stack * 0.3, 1, 0])
cnt_p_3bet_opp_30max:
sum(if[tourney_hand_player_statistics.flg_p_3bet_opp AND tourney_hand_player_statistics.amt_p_2bet_facing <= tourney_hand_player_statistics.amt_p_effective_stack * 0.3, 1, 0])
The problem might be because you haven't explicitly set the database table name for amt_p_effective_stack. When I test those versions on my end they work properly.
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by supaflyer » Fri Sep 05, 2014 3:56 pm
Still the same, works only partly. When I shove 90% of my stack the number of opportunities increases, but below the "This session: " works fine.
-
supaflyer
-
- Posts: 32
- Joined: Mon Feb 24, 2014 7:24 am
by kraada » Fri Sep 05, 2014 4:55 pm
Rebuild your custom cache (and just the custom cache) via Database Management and that should fix it then.
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 9 guests