Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by Rebellz » Wed Aug 08, 2018 5:40 am
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.
-
Rebellz
-
- Posts: 16
- Joined: Fri Mar 07, 2008 11:29 am
by Flag_Hippo » Wed Aug 08, 2018 12:20 pm
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.
-
Flag_Hippo
- Moderator
-
- Posts: 14505
- Joined: Tue Jan 31, 2012 7:50 am
by Rebellz » Wed Aug 08, 2018 2:20 pm
Thank you
-
Rebellz
-
- Posts: 16
- Joined: Fri Mar 07, 2008 11:29 am
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 17 guests