Custom stats with CBets

[rebornok]

Because of some problems with parcing cbets maybe it's better to use another column?
cnt_f_cbet_2 = sum(if[(substring(lookup_actions_f.action from 1 for 1) = 'B') AND (holdem_hand_player_detail.val_p_raise_aggressor_pos = holdem_hand_player_statistics.position)])
Is it correct and made it sense?

[rebornok]

Sorry, forgot "1,0"
sum(if[(substring(lookup_actions_f.action from 1 for 1) = 'B') AND (holdem_hand_player_detail.val_p_raise_aggressor_pos = holdem_hand_player_statistics.position),1,0])

[kraada]

There's a flg_f_cbet in the holdem_hand_player_statistics table that is true when a player cbets. I'm not aware of any problems with that flag; have you found times when you think it should be a cbet but isn't (or vice versa)?

[WhiteRider]

You should also be aware that currently holdem_hand_player_detail.val_p_raise_aggressor_pos is -1 if the player was the preflop aggressor.
I have suggested to the development team that it should be the player's real position, but there may be something I haven't considered which makes -1 a better idea.
Also, holdem_hand_player_detail.val_p_raise_aggressor_pos currently doesn't store the blind positions correctly - I expect this to be fixed in the next release because I know that the development team have been working on this issue.

[rebornok]

Thank you!
To WhiteRider: I'll correct the expression with positions.
To Kraada: I mean this threads: viewtopic.php?f=15&t=14306&p=66761&hilit=flg_f_cbet#p66761 and viewtopic.php?f=16&t=11948&p=55777#p55777.
So, cnt_t_cbet_opp, cnt_r_cbet_opp and - cnt_cbet_def_action_fold/call/raise - are they ok now?

[kraada]

I'm not sure if that bug has been fixed, but I'll check.

[WhiteRider]

I'm not sure if that bug has been fixed, but I'll check.

Kraada is away for the weekend now, but I've checked and the hand history you posted here works correctly in Beta 23.
Fold to cbet and call cbet are both 0/1 and raise c-bet is 1/1, for opp3.