4StarGen wrote:4StarGen wrote:Column
- Code: Select all
CASE WHEN cash_hand_player_statistics.flg_p_3bet THEN (cash_hand_player_statistics.amt_p_raise_made / cash_hand_player_statistics.amt_p_raise_facing)::text ELSE '0' END
Regarding the hand I've posted, I've tested the val_p_3bet_size in a hand report and it shows a wrong number.
Which "wrong" number are you referring to? The 0.76923076923076 for your '
last_3_bet_size' custom statistic or 1 for the '
val_p_3bet' custom statistic? Or both?
This column is for which of the two statistics? Based on the calculations below it's for your
'last_3bet_size' custom statistic so I assume that's the one you are saying is "wrong" and that's all I can check.
In that hand the size of the small blinds first raise
(cash_hand_player_statistics.amt_p_raise_made) is 10.
The size of the last raise faced (
anything using 'facing' is the amount needed to call) by the small blind
(cash_hand_player_statistics.amt_p_raise_facing) is 13 (note - the values wouldn't actually be 10 and 13 in the database since it would be based on chips and not BBs but for the purposes of the calculation the ratio between the two would still be the same).
10 / 13 = 0.76923076923076 (this is the value in your report and correct based on the custom statistic you have created).
You haven't answered my question regarding "size" in my previous reply so I still don't know exactly what kind of "size" statistic you are after or what the "right" number should be. Assuming you want the ratio of the size of the 3bet to the size of the 2bet (10 / 3 = 3.33) then you would need to use
cash_hand_player_statistics.amt_p_2bet_facing instead of
cash_hand_player_statistics.amt_p_raise_facing.
If you are actually querying the result of your '
val_3bet' custom statistic then we would need the details of that instead. Bear in mind that if you have used some sort of expression from default columns (such as
val_p_3bet_size or
val_p_3bet_size_x) then those are used for the default statistics
'Preflop 3Bet Size' &
'Preflop 3Bet Relative Size' and those don't actually record an absolute value of 3Bet size since they are grouping stats.