Pot bet stat

[kingreigns]

Anyone feel like helping making me a pot bet stat and fold to pot bet stat for each street? I have an overbet stat and i had a look at the columns but i dont know how to edit it to make it a pot size bet

[WhiteRider]

If you post the column expressions for your existing overbet stat we'll be able to show you how to adapt them.

[kingreigns]

Cool, so overbet flop is: (cnt_f_overbet / cnt_f_overbet_opp) * 100

The expression for cnt_f_overbet is:
sum(if[cash_hand_player_statistics.val_f_bet_made_pct > 100, 1, 0])

The expression for cnt_f_overbet_opp is:
sum(if[cash_hand_player_statistics.val_f_bet_facing_pct > 50, 1, 0])

[WhiteRider]

Those expressions are counting different situations.
"cnt_f_overbet" tests for the player betting a certain amount (more than the pot size) specifically as a bet.
"cnt_f_overbet_opp" tests for the player facing a bet.
However, if you face a bet then you can't bet (you can only raise).

To test for an opportunity to bet more than is in the pot you'd need to test for "cash_hand_player_statistics.amt_f_effective_stack > cash_hand_summary.amt_pot_f".

"cash_hand_player_statistics.val_f_bet_made_pct" is the size of the bet as a percentage (that's what _pct represents) of the pot size. So an exactly pot sized bet would be "cash_hand_player_statistics.val_f_bet_made_pct = 100". You may want to test for values in a range though, rather than exact sizes.

[kingreigns]

So when im putting "cash_hand_player_statistics.val_f_bet_made_pct = 100" into the expression part of the column, what will the name be for it?
Shouldn't there be a second one since all stats are made up of two expressions like " (cnt_f_overbet / cnt_f_overbet_opp) * 100" for overbet flop?

[kingreigns]

I'm a bit confused now, does this mean my overbet stats is created wrong? Heres screenshots of it

http://i.imgur.com/tbi7SJM.jpg


The expressions in the colums
http://i.imgur.com/8Yy5jfM.jpg



http://i.imgur.com/2SAIkKx.jpg

[WhiteRider]

Your overbet stat looks fine.

Yes, you will need to make a pair of new columns. You can duplicate the existing columns and alter the expressions to match how you want to define a pot size bet (e.g. whether it's exactly 100%, or between 90% and 110% for example). You can name your columns whatever you like, but I'd suggest something similar to what you already have so that you can tell what the names mean.

[kingreigns]

Do you mean duplicate the overbet columns and adjust them?
I made two columns based off what you said before that but i have no idea if this is what you were on about. If they are right , which comes first when making the actual stat?

1st one:
http://i.imgur.com/33h0TJw.jpg

2nd column:
http://i.imgur.com/W3NAf69.jpg

I pressed validate and the expressions are valid but the first time i press save this appeared.
http://i.imgur.com/ZTHO7ZV.jpg

[WhiteRider]

Do you mean duplicate the overbet columns and adjust them?

Yes, this is what you'll need to do. Your new columns will need to be in the same type of format as the existing ones though - you can't just paste in parts of expressions like that.

Take a look at the Custom Stats Guide for an overview of how custom stats work, and the Tutorial: Custom Reports and Statistics goes into much more detail with examples of how to make new versions of stats based on existing ones (amongst other things).

[kingreigns]

Hmmm,i tried this. I duplicated cnt_f_overbet, renamed it "cnt_f_potbet" and put this in the expression "sum(if[cash_hand_player_statistics.amt_f_effective_stack > cash_hand_summary.amt_pot_f)" and when i try to validate it say" statement is not SQL

If i put in "(cash_hand_player_statistics.amt_f_effective_stack > cash_hand_summary.amt_pot_f)" the statement is valid.Then when i try to save it say "The column cannot be cached.Error the column is not cacheable.
I'm not sure where im going wrong