How can I get my stats against specific type of players

[kilipo]

Hi,

I'd like to see my stats against specific players in PT3, for example players who currently have a VP$IP > 40 in my database, for at least 50 hands played. I don't see how I could do this with the filters button or the reports tab. Hope you can help me one more time! ;)

[kraada]

This filter in the blue Filters link in PT3 gets you data against all players with VPIP between 40 and 100.


holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from player, holdem_hand_player_statistics where player.id_player = holdem_hand_player_statistics.id_player GROUP BY player.id_player HAVING (((( (CASE WHEN ( (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end)))) <> 0 THEN (((sum((case when(holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) * 1.0 )/( (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))))) ELSE 0 END) ) * 100) BETWEEN 40 AND 100)))

This filter is complex and expect any report using it to take a considerable amount of time to show you data.

[kilipo]

I clicked on the blue filters link in the report tab and i copy-pasted your filter, but when I click on "save" it tells me that the expression in not valid. Help :mrgreen:

[kraada]

My apologies, I missed a small piece.

This will work:


holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from player, holdem_hand_player_statistics where player.id_player = holdem_hand_player_statistics.id_player GROUP BY holdem_hand_player_statistics.id_hand, player.id_player HAVING (((( (CASE WHEN ( (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end)))) <> 0 THEN (((sum((case when(holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) * 1.0 )/( (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))))) ELSE 0 END) ) * 100) BETWEEN 40 AND 100)))

[kilipo]

Thank you, it is accepted by pt3 now.

I have troubles to understand how to use the data from the report created with this filter. For instance is it possible to see my cbet success percentage against players with a VPIP between 40 and 100?

[kraada]

Yes, just make sure you're filtering on active player and add cbet success to the stat list. If you want these players to have seen the flop you'll have to make one small addition:


holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from player, holdem_hand_player_statistics where player.id_player = holdem_hand_player_statistics.id_player WHERE holdem_hand_player_statistics.flg_f_saw GROUP BY holdem_hand_player_statistics.id_hand, player.id_player HAVING (((( (CASE WHEN ( (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end)))) <> 0 THEN (((sum((case when(holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) * 1.0 )/( (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))))) ELSE 0 END) ) * 100) BETWEEN 40 AND 100)))

[kilipo]

Ok, it makes sense. But the expression is not valid.

[kraada]

Sorry, this works:


holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from player, holdem_hand_player_statistics where player.id_player = holdem_hand_player_statistics.id_player AND holdem_hand_player_statistics.flg_f_saw GROUP BY holdem_hand_player_statistics.id_hand, player.id_player HAVING (((( (CASE WHEN ( (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end)))) <> 0 THEN (((sum((case when(holdem_hand_player_statistics.flg_vpip) then 1 else 0 end))) * 1.0 )/( (sum((case when(holdem_hand_player_statistics.id_hand > 0) then 1 else 0 end))))) ELSE 0 END) ) * 100) BETWEEN 40 AND 100)))