Filter hero hands vs particular type of opponent

[gigenieks]

I want to filter all hands where I was involved in pot vs. opponent who would have stats:

• VPIP 24 or more
• PFR 20 or more
• AF 3 or more
• WSF 35 or more

How can I do this? :?:

[gigenieks]

I really need this. Anyone? :?

[gigenieks]

I would appreciate any help... If not with filters, maybe there is another way to do this?!

[pt4pt4pt4]

I think the main problem is that the results take so long to be filtered, check the PT4 custom filters section for similar question.

[gigenieks]

bump

[WhiteRider]

This thread has the expression that you need - if you're playing cash replace tourney_ with cash_.

[gigenieks]

Well I don't understand... Can you please give me step-by-step? :?

[WhiteRider]

Go to the My Reports page and create a new "Hands" report. Click the blue Filters link and select "expression filters" and paste that filter expression in.
Click the green question mark (or grey monitor if you haven't updated yet) icon on the My Reports page to watch the tutorial video for more information on working with custom reports.

[gigenieks]

"Go to the My Reports page and create a new "Hands" report. Click the blue Filters link and select "expression filters" and paste that filter expression in."
I did it. But this only filters by VPIP. I want to add PFR, AF, WSF.

"Click the green question mark (or grey monitor if you haven't updated yet) icon on the My Reports page to watch the tutorial video for more information on working with custom reports."
It doesn't work. First it asked to download Adobe Flash Player. When I did and successfully instaled it. It asks again for Adobe Flash Player...
Maybe someone can provide me with instructional links on this?

But meanwhile can we finish the report I intended in first post by adding additional filtering (PFR, AF etc)??! :?:

[kraada]

You can add more things into the HAVING clause. To see the columns you need to reference, look in the Configure -> Statistics window at the Value Expression for your stats, you just need to prefix them with tc. in this case because of the way the query is constructed.

For example, this gives you VPIP of 15 to 25 and PFR of 20 to 40:

tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, tourney_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)))) BETWEEN 15 and 25 AND (sum(tc.cnt_pfr) / (sum(tc.cnt_pfr_opp)))) BETWEEN 20 and 40)))