Flag_Hippo wrote:I cannot tell how your custom statistic is defined from just the column names so please post the expressions from your custom columns here, via PM or in a
Support Ticket.
Sorry. I think this is what you need:
cnt_r_bet_bluff
sum(if[((cash_hand_player_combinations.flg_r_highcard) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength < 3) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 4) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 5) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength < 3) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength = 4) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength = 5) OR (cash_hand_player_combinations.flg_r_threeoak AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_straight AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_flush AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_fullhouse AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_fouroak AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_strflush AND cash_hand_player_combinations.id_r_hand_strength = 0)) AND (cash_hand_player_statistics.flg_r_bet) AND NOT (cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand), 1, 0])
cnt_r_bet_known
sum(if[cash_hand_player_statistics.flg_r_bet AND cash_hand_player_statistics.id_holecard>0, 1, 0])
cnt_r_raise_bluff
sum(if[((cash_hand_player_combinations.flg_r_highcard) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength < 3) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 4) OR (cash_hand_player_combinations.flg_r_1pair AND cash_hand_player_combinations.id_r_hand_strength = 5) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength < 3) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength = 4) OR (cash_hand_player_combinations.flg_r_2pair AND cash_hand_player_combinations.id_r_hand_strength = 5) OR (cash_hand_player_combinations.flg_r_threeoak AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_straight AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_flush AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_fullhouse AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_fouroak AND cash_hand_player_combinations.id_r_hand_strength = 0) OR (cash_hand_player_combinations.flg_r_strflush AND cash_hand_player_combinations.id_r_hand_strength = 0)) AND (cash_hand_player_statistics.cnt_r_raise > 0) AND NOT (cash_hand_player_statistics.flg_showdown AND cash_hand_player_statistics.flg_won_hand), 1, 0])
cnt_r_raise_known
sum(if[(cash_hand_player_statistics.cnt_r_raise > 0) AND (cash_hand_player_statistics.id_holecard>0), 1, 0])