I want to creat the following stats

[JohnDonJuan]

Fold to Delay cbet 3bet pot,
Fold to Float bet 3bet pot Flop,
Fold to Float bet 3bet pot Turn,
Fold to Float bet 3bet pot River.

[Flag_Hippo]

Fold to Float bet 3bet pot Flop,
Fold to Float bet 3bet pot Turn,
Fold to Float bet 3bet pot River.

You can duplicate and edit the existing columns for the built-in float statistics and add the following code to make columns that are 3bet pot specific:

Code: Select all

char_length(cash_hand_summary.str_aggressors_p) = 3

You can then build the new custom statistics from the new custom columns - see this guide for the basics on custom statistics creation and replace "cash" with "tourney" if this is for tournament statistics.

Fold to Delay cbet 3bet pot,

If you mean on the turn then there is a 'Fold to Delayed Turn CBet' in the Download Warehouse and that can be edited in the same way as mentioned above.

[JohnDonJuan]

i done the following for Fold to Turn Float 3bet pot.
sum(if[cash_hand_player_statistics.enum_t_float_action='F', 1, 0]) char_length(cash_hand_summary.str_aggressors_p) = 3
And I cannot save it. It says "The statement is not valid SQL".

[JohnDonJuan]

https://imgur.com/a/GY5hdO1
I already have the stat Fold to Turn delay cbet and I changed char_length(cash_hand_summary.str_aggressors_p) = 2 into char_length(cash_hand_summary.str_aggressors_p) = 3 and I was able to validate it and save it but when I went to look for it to put in my HUD I couldn't find it anywhere.
https://imgur.com/a/2UUBlZe
https://imgur.com/a/jbhmM8r

[Flag_Hippo]

i done the following for Fold to Turn Float 3bet pot.
sum(if[cash_hand_player_statistics.enum_t_float_action='F', 1, 0]) char_length(cash_hand_summary.str_aggressors_p) = 3
And I cannot save it. It says "The statement is not valid SQL".

You need to put the additional code within the sum(if[, 1, 0]) statement with an AND:

sum(if[cash_hand_player_statistics.enum_t_float_action='F' AND char_length(cash_hand_summary.str_aggressors_p) = 3, 1, 0])

I already have the stat Fold to Turn delay cbet and I changed char_length(cash_hand_summary.str_aggressors_p) = 2 into char_length(cash_hand_summary.str_aggressors_p) = 3 and I was able to validate it and save it but when I went to look for it to put in my HUD I couldn't find it anywhere.

Have you created the new statistic in the 'Stats' tab with your new column names? Until you do that it will not be available to add to your HUD. Please read the custom statistic guide so you can understand how the system works:

Guide: Custom Statistics

[JohnDonJuan]

Do I create the column first or the stat? What do I put in the Value Expression? I attached a link below.
https://imgur.com/a/SxbonNy
https://imgur.com/a/5O7spqE

[Flag_Hippo]

You can only create a statistic if the custom columns exist so create those first. If the custom columns do not exist you will get an 'Invalid Value Expression' error as per your screenshot.

[JohnDonJuan]

I have created the columns but still don't know how to get it to appear or what to put in the "Value Expression"
https://gyazo.com/dbf07e8da613aa34281a280bdc1be1a4
https://gyazo.com/779062fdbedad8ea6f9fc105a8c9f16f

[Flag_Hippo]

Most custom statistics (look at other statistics in PokerTracker 4 as an example) use this format for the 'Value Expression':

Code: Select all

(a / b) * 100

where 'a' and 'b' are the column names.