Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by CherryWaves » Fri Sep 02, 2022 11:58 am
Hello I want to do a custom report for the below situation.
I want to use the below filters (see attached image) but vs a particular regular or group of regulars.
Is it possible to look at winrates with the below situation vs certain regulars?
Thank you
-
CherryWaves
-
- Posts: 64
- Joined: Thu Jul 10, 2014 9:14 am
by CherryWaves » Fri Sep 02, 2022 12:02 pm
I dont know why but everytime i try to upload an attachment, it keeps asking me to log in:
But the filters are:
Players dealt into hand 3-6
Position of player = 9
Stack size 9-11bb
Limped first in
Specific Range of hands
-
CherryWaves
-
- Posts: 64
- Joined: Thu Jul 10, 2014 9:14 am
by Flag_Hippo » Sat Sep 03, 2022 5:49 am
If you want to filter hands where a specific player was dealt into a hand of yours then that would require a custom expression filter like this:
- 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 = 'Villain')
Replace Villain with a screen name and leave the single quotes - those are needed. You can use this expression filter by clicking on the 'Filters' link in a custom report and selecting 'Add New Expression Filters'.
-
Flag_Hippo
- Moderator
-
- Posts: 14440
- Joined: Tue Jan 31, 2012 7:50 am
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 17 guests