Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by BloMur » Mon Jul 29, 2024 3:50 am
I would like to separate hands played against regs. So far I was just typing and searching their nicknames one by one and tagging selected hands. Is there a faster way to do it ?
-
BloMur
-
- Posts: 58
- Joined: Fri Nov 24, 2017 7:47 pm
by Flag_Hippo » Mon Jul 29, 2024 6:33 am
If you are defining a "reg" as someone that has statistics within a specified range then you can build a custom filter for that - see
this thread.
-
Flag_Hippo
- Moderator
-
- Posts: 15219
- Joined: Tue Jan 31, 2012 7:50 am
by BloMur » Mon Jul 29, 2024 11:26 am
I defining reg as someone I played most tournaments/hands against and I have a treshold number for this. Is it even possible to filter this ?
-
BloMur
-
- Posts: 58
- Joined: Fri Nov 24, 2017 7:47 pm
by Flag_Hippo » Mon Jul 29, 2024 12:21 pm
- Code: Select all
tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, tourney_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player having (sum(tc.cnt_hands) >= x and not thps.flg_hero))
where 'x' is the minimum number of hands you want.
-
Flag_Hippo
- Moderator
-
- Posts: 15219
- Joined: Tue Jan 31, 2012 7:50 am
by BloMur » Mon Jul 29, 2024 5:19 pm
How would I also go about adding specific position on reg in question ? In 3-way (BTN, BB, SB) and HU spots ?
-
BloMur
-
- Posts: 58
- Joined: Fri Nov 24, 2017 7:47 pm
by Flag_Hippo » Tue Jul 30, 2024 6:05 am
- Code: Select all
tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, tourney_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player having (sum(tc.cnt_hands) >= x and not thps.flg_hero and thps.position = y))
where 'y' is the player position.
-
Flag_Hippo
- Moderator
-
- Posts: 15219
- Joined: Tue Jan 31, 2012 7:50 am
by BloMur » Tue Jul 30, 2024 6:57 am
What about 3way and HU, How to differentiate if there was 2 or 3 player preflop.
-
BloMur
-
- Posts: 58
- Joined: Fri Nov 24, 2017 7:47 pm
by BloMur » Tue Jul 30, 2024 8:01 am
This method works, but the problem is database size. On big database I was unable to load hands, It is stuck on "loading..." for several hours. Is there a way to speed up this process ?
-
BloMur
-
- Posts: 58
- Joined: Fri Nov 24, 2017 7:47 pm
by Flag_Hippo » Tue Jul 30, 2024 12:04 pm
BloMur wrote:How to differentiate if there was 2 or 3 player preflop.
- Code: Select all
tourney_hand_summary.cnt_players = z and tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, tourney_cache tc where thps.id_player = tc.id_player group by thps.id_hand, thps.id_player having (sum(tc.cnt_hands) >= x and not thps.flg_hero and thps.position = y))
where 'z' is the number of players dealt into the hand.
BloMur wrote:This method works, but the problem is database size. On big database I was unable to load hands, It is stuck on "loading..." for several hours. Is there a way to speed up this process ?
Did you start using a built-in filter for the number of players? If you did then clear that and filter for everything you need inside the expression filter.
-
Flag_Hippo
- Moderator
-
- Posts: 15219
- Joined: Tue Jan 31, 2012 7:50 am
by BloMur » Tue Jul 30, 2024 12:34 pm
I only used expression filter and still it is stuck in "loading...". I even deleted all the info about hand (like time, hole cards etc) and left only hand# and it did not helped.
-
BloMur
-
- Posts: 58
- Joined: Fri Nov 24, 2017 7:47 pm
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: WhiteRider and 8 guests