then, i must see on vpip stat the columns it uses cnt_vpip ---> dup it and change for --> sum(if[holdem_hand_player_statistics.flg_vpip AND holdem_hand_player_statistics.position = 0, 1, 0]) -from buttom- and rename it cnt_vpip_bu then cnt_hands --> dup it and change this: sum(if[holdem_hand_player_statistics.id_hand > 0, 1, 0]) for ??? i'm lost with this change thank you
sum(if[holdem_hand_player_statistics.id_hand > 0 AND holdem_hand_player_statistics.position = 0, 1, 0])
This is a bit of a strange one, but basically it's counting all hands where the hand ID is greater than zero, which is all hands. If we add a check for position = 0 then it will find all hands for position zero.