Variations on the same statistic

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Variations on the same statistic

Postby 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

Re: Variations on the same statistic

Postby 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: 14441
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 16 guests

cron
highfalutin