PokerTracker

filter for hands Hero has played vs villains with a higher vpip than 40?

Use this filter expression in a custom report:
cash_hand_player_statistics.id_hand in (SELECT thps.id_hand from cash_hand_player_statistics thps, cash_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player HAVING ( (sum(tc.cnt_vpip) / (sum(tc.cnt_hands) - sum(tc.cnt_walks))) >= 40) )

1. I click on tab reports.
2. I pick new report. I save this report.
3. I click on filters. I choose "edit existing expression filters".
5. I insert your code. I toggle for active player. I press save.
6. Nothing happens.

What am I doing wrong?

I think there may be a "100" missing, so the original expression is comparing a decimal against a percentage. Try changing "40" to "0.40".

Nope. For player report and all players report it just says loading and nothing happens for ages. For hand report, it says it's unable to execute query.

WhiteRider is right about the decimal part - how large is your database though? Do you ever see it change from Loading to Populating?

It's about 800k hands. Nope, never populating. Just loading for hours.

Unfortunately these kinds of filters can take an awfully long time. If I can think of a better way to do it, I'll let you know.

Thanks.