Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
friidayy wrote:Hello, I want to determine the average coldcallingrange of fishes. I use the range report in the my reports tab and use the following filters: not hero & cold called preflop. How can I additionally filter for players that have a vpip greater than, lets say, 35? I already tried to use expression filter with #VPIP#>35, but it does not work.
player.id_player in (SELECT p.id_player from player p, cash_cache cc where p.id_player = cc.id_player group by p.id_player HAVING (( sum(cc.cnt_vpip) / (sum(cc.cnt_hands) - sum(cc.cnt_walks)) > .35)))
friidayy wrote:Another question I have is, how can I look at the coldcalling hands of my opponents? When I use the hand report tab with the same filter, I can not see any hands, because I filtered for not hero and the tab seems to show only hero hands.
cash_hand_player_statistics.date_played > '2022/01/01 00:00:00' and player.id_player in (SELECT p.id_player from player p, cash_cache cc where p.id_player = cc.id_player group by p.id_player HAVING (( sum(cc.cnt_vpip) / (sum(cc.cnt_hands) - sum(cc.cnt_walks)) > .35)))
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 27 guests