Different Villain Filters in Hand Report

[IA06]

I've created a Hand Report to review the player pool. I see V hands and such, so all good there.

Now I want to add Expression filters to filter out for different, let´s call it "Player Types".

For example I only want to see the hands from players who has a total of >= 70% Flop CBet frequency, or Preflop 3Bet <= 5%.

Hopefully you can see what I'm looking to accomplish here.
If you can point me in the right direction I´d be thankfull.

[Flag_Hippo]

See this thread for an example - the example is for VPIP and number of hands but the principle is the same.

[IA06]

The expression from that thread ends up as "Expression not valid".

cash_hand_player_statistics.id_hand in (select chps.id_hand from cash_hand_player_statistics chps, cash_cache cc where chps.id_player = cc.id_player group by chps.id_hand, chps.id_player having ((sum(cc.cnt_vpip) * 1.0) / (sum(cc.cnt_hands) * 1.0) - sum(cc.cnt_walks) * 1.0) < .35 and (sum(cc.cnt_hands) > 1000 and not chps_flg_hero))

Not sure what could be wrong with it.

[Flag_Hippo]

Thanks - there was an error in there which I have now fixed in the original post (chps_flg_hero was being used instead of chps.flg_hero).

[IA06]

Thank you.

I've filtered for only hands of this year and that is like 6.5k hands. This expression filter takes extremely long time. It only says loading and nothing happens. Sure, that's probably normal for databases of +300k hands I guess.
Or it does'nt matter that I filtered out to a smaller amount of hands with the built in filters? It still goes through the whole database?

[Flag_Hippo]

This data isn't cached and may take some time regardless of any other filters you are using.