Filter Against Player Type

[pat3392]

I want to run a complex filter, that looks at my 3bet success from the blinds against a BU opener who's VPIP is <30, and PFR no less than 15% of his VPIP number. I also want to filter it for when I have at least 50 hands on villain. Can this be done? If so, what would be the expression for it?

[kraada]

It can be done from a technical standpoint but filters like this make reports take an extremely long time, especially if you have a large database. Would you be willing to wait upwards of an hour for this report to return data?

[pat3392]

yup

[kraada]

Use simple filters for times you had a 3bet opportunity in A&O -> Preflop -> Opportunity and to get the times you were in a blind.

This filter expression will guarantee that the open raise from the button came from a player with VPIP < 30:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from player p, cash_cache cc, cash_hand_player_statistics chps where chps.id_player = p.id_player and (p.id_player = cc.id_player) and chps.position = 0 and chps.flg_steal_att GROUP BY cc.id_player, chps.id_hand HAVING ((( (CASE WHEN ( (sum(cc.cnt_hands) - sum(cc.cnt_walks))) <> 0 THEN ( (CASE WHEN (( (sum(cc.cnt_hands) - sum(cc.cnt_walks)))) <> 0 THEN (((sum(cc.cnt_vpip) * 1.0 )* 1.0 )/(( (sum(cc.cnt_hands) - sum(cc.cnt_walks) )))) ELSE 0 END) ) ELSE 0 END) ) * 100) < 30))

This gets you PFR >= 4.5:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from player p, cash_cache cc, cash_hand_player_statistics chps where chps.id_player = p.id_player and (p.id_player = cc.id_player) and chps.position = 0 and chps.flg_steal_att GROUP BY cc.id_player, chps.id_hand HAVING ((( (CASE WHEN ( (sum(cc.cnt_pfr_opp))) <> 0 THEN ( (CASE WHEN (( (sum(cc.cnt_pfr)))) <> 0 THEN (((sum(cc.cnt_pfr) * 1.0 )* 1.0 )/(( (sum(cc.cnt_pfr_opp))))) ELSE 0 END) ) ELSE 0 END) ) * 100) >= 4.5))

Use both as separate Filter Expressions and just expect it to take a good long time.