Page 1 of 1

Collision rate in spins

PostPosted: Wed Aug 08, 2018 5:40 am
by Rebellz
Hello, I'm doing an investigation and I'd like to know If there is a way to check the collision rate of two specific players on my PT4 database.

I want to see if player A and player B ever played together at the same table, how often they played together etc, I'm pretty sure there is a way to check that but I don't know how.

Re: Collision rate in spins

PostPosted: Wed Aug 08, 2018 12:20 pm
by Flag_Hippo
You can filter for two players in the same hand with the following expression filter in a custom report:

Code: Select all
tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where thps.id_player = p.id_player and p.player_name = 'Player1') and tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p where thps.id_player = p.id_player and p.player_name = 'Player2')

You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. Replace Player1 & Player2 with screen names and leave the single quotes in the expression filter.

Re: Collision rate in spins

PostPosted: Wed Aug 08, 2018 2:20 pm
by Rebellz
Thank you

highfalutin