Hi
I'm trying to create stats to differentiate between where a player called an open raise and where a player called behind in a multi way pot. I've been using ' squeeze '' but without success. For some reason, my stats don't populate on the HUD . I've done a full cache rebuild in case it was that but still no luck.
Call PF Raise is sum(if[tourney_hand_player_statistics.amt_p_2bet_facing > 0 AND ((NOT(tourney_hand_player_statistics.flg_p_limp) AND lookup_actions_p.action LIKE 'C%') OR lookup_actions_p.action SIMILAR TO '(C|X)C%'), 1, 0]) / sum(if[tourney_hand_player_statistics.amt_p_2bet_facing > 0, 1, 0])
All I've done is add the squeeze part in for multi way calls and not squeeze where the player is the first caller
eg
sum(if[tourney_hand_player_statistics.amt_p_2bet_facing > 0 and tourney_hand_player_statistics.flg_p_squeeze_opp AND ((NOT(tourney_hand_player_statistics.flg_p_limp) AND lookup_actions_p.action LIKE 'C%') OR lookup_actions_p.action SIMILAR TO '(C|X)C%'), 1, 0]) / sum(if[tourney_hand_player_statistics.amt_p_2bet_facing > 0 and tourney_hand_player_statistics.flg_p_squeeze_opp, 1, 0])
Whats going wrong ?