Hi,
I want to show VPIP for when only 6 players are dealt into a hand :
so i changed VPIP : (cnt_vpip / (cnt_hands - cnt_walks)) * 100 to (cnt_vpip_6players / ( cnt_hands_6players - cnt_walks_6players)) * 100
here are the columns:
sum(if[cash_hand_player_statistics.flg_vpip
AND cash_hand_player_statistics.id_player = 6 , 1, 0])
sum(if[cash_hand_player_statistics.id_hand > 0 AND cash_hand_player_statistics.id_player = 6, 1, 0])
sum(if[lookup_actions_p.action = ''
AND cash_hand_player_statistics.id_player = 6, 1, 0])
What went wrong?