HH REPORT - Expression filter

[blom90]

Hi,

I wanna filter hands played and only show hands played where I faced a villain with a VPIP-PFR gap of >14. Is that possible to create? I guess we need to use expression filter for this?

[Flag_Hippo]

If them just being dealt in the is hand enough then you can use this expression filter:

Code: Select all

cash_hand_player_statistics.id_hand in (select chps.id_hand from cash_hand_player_statistics chps where chps.id_player in (select cc.id_player from cash_cache cc where true group by cc.id_player having (((sum(cc.cnt_vpip) * 1.0) / (sum(cc.cnt_hands) * 1.0) - sum(cc.cnt_walks) * 1.0) - (sum(cc.cnt_pfr) * 1.0 / sum(cc.cnt_pfr_opp) * 1.0)) > .14))