PokerTracker

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?

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.