Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by ButtonM@sher » Wed Apr 13, 2022 1:08 pm
Is there a way to pass a variable into a column? For example,
sum(if[tourney_hand_player_statistics.flg_p_ccall AND (tourney_hand_player_statistics.id_holecard=VAR), 1, 0])
would sum all the times a player cold called preflop with the hand VAR, instead of creating a separate column for each hand of interest?
-
ButtonM@sher
-
- Posts: 2
- Joined: Thu Dec 05, 2019 11:59 pm
by Flag_Hippo » Thu Apr 14, 2022 6:37 am
A column in PokerTracker 4 is a variable but columns themselves cannot use variables. Do you mean you want to test for a range of holecards in a column instead of one specific holding? If so you can do that like this:
- Code: Select all
sum(CASE WHEN tourney_hand_player_statistics.flg_p_ccall AND tourney_hand_player_statistics.id_holecard in (1,26,49,70,89,106,121,134,145,154,161,166,169) THEN 1 ELSE 0 END)
This example is for all pocket pairs.
-
Flag_Hippo
- Moderator
-
- Posts: 14505
- Joined: Tue Jan 31, 2012 7:50 am
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 33 guests