How to:

[foodformoney]

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

[kraada]

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) )

[foodformoney]

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?

[WhiteRider]

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".

[foodformoney]

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.

[kraada]

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

[foodformoney]

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

[kraada]

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.

[foodformoney]

Thanks.