Can you search how you do against certain players?

[Kombaiyashii]

That is their collective winrate - they are on average losing 9.4bb/100.

So, how do I get my winrate vs these players? Is that possible?

[kraada]

You'll actually want a different style of report then.

Create a different Player report that just displays yourself (keep Filter on Active Player on), and add the following text to the blue Filters area:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cache_cache cc where chps.id_player = cc.id_player group by chps.id_player, cc.id_player HAVING ((( (CASE WHEN ( (sum(cc.cnt_hands) - sum(cc.cnt_walks))) <> 0 THEN ((sum(cc.cnt_vpip) * 1.0 )/( (sum(cc.cnt_hands) - sum(cc.cnt_walks)))) ELSE 0 END) ) * 100) BETWEEN X and Y)

Change X and Y to be the VPIP range you want for your opponents in this case BETWEEN 30 and 50 will let you see what you want.

[Kombaiyashii]

Thanks man, however something seems a little wrong with the coding, it is saying that expression is not valid, that's after I changed x and x to 30 and 50.

[kraada]

My apologies.

This validates and works:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps where chps.flg_vpip and chps.id_player in (SELECT cc.id_player from cash_cache cc group by cc.id_player HAVING ((( (CASE WHEN ( (sum(cc.cnt_hands) - sum(cc.cnt_walks))) <> 0 THEN ((sum(cc.cnt_vpip) * 1.0 )/( (sum(cc.cnt_hands) - sum(cc.cnt_walks)))) ELSE 0 END) ) * 100) BETWEEN X and Y)))

Note this gets you your results in hands where one of these players put money in.

[Kombaiyashii]

hmm, I might be doing something wrong...

I copy and past what you've wrote into the blue filters field. Then I have changed the "X and X" to 30 and 50 but still it's not coming up with a valid expression...I'm using version PT3 3.12.1

[WhiteRider]

Kraada has give you the PT4 version of the filter by accident. Try this:

holdem_hand_player_statistics.id_hand in (SELECT chps.id_hand from holdem_hand_player_statistics chps where chps.flg_vpip and chps.id_player in (SELECT cc.id_player from holdem_cache cc group by cc.id_player HAVING ((( (CASE WHEN ( (sum(cc.cnt_hands))) <> 0 THEN ((sum(cc.cnt_vpip) * 1.0 )/( (sum(cc.cnt_hands)))) ELSE 0 END) ) * 100) BETWEEN 30 and 50)))

[Kombaiyashii]

Really sorry to be such a pain...I'm getting this error now:

[WhiteRider]

It works fine for me in that exact setup.
I've attached my version of the report. Extract the file from the .zip and import it by clicking the Import button at the bottom of the custom reports page.

[Kombaiyashii]

Doh, we are not having much luck here Now I'm getting this:



Could it have something to do with it being your filter which is looking for your hands and not my username?

[WhiteRider]

No, there's nothing in that filter which is specific to anyone.
Please enable logging, restart PT3 and report your problem - your logs will let us see the full error message to see what is going on.