Filter "vs specific player"

[JohnyK91]

Hello,

I am trying to see how my play deviates from normal when I am playing a specific player. For example, I want to compare my Fold Vs Btn with my Fold Vs Btn when Btn is the specific player, Attempt to Steal from LP vs Attempt to Steal from LP when specific player is sitting on bb, etc.. I would like to do that for 5-10 stats.

My guess is that I need to create them but whatever I have tried so far, has miserably failed.

Any ideas on how to create the stats?

Thanks

[Flag_Hippo]

To see your stats when a specific player was in on the button go to 'My Reports' and create a custom player report. Make sure you're the active player and create a report with whatever stats you want to see. Next use this expression in the blue Filters link -> Add Filter Expressions area:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p where chps.id_player = p.id_player and p.player_name = 'Villain' and chps.position = 0)

Replace Villain with a screen name and leave the single quotes - those are needed. You will also need to add simple filters to specify your own position and that you are facing a steal from the button. If you want to see a different situation with the player in the BB instead then change the position value in the expression filter from 0 to 8.

[JohnyK91]

That was extremely helpful. Worked right away.

Thanks again!