Bet Turn % after c/r Flop

[js2002]

We have the build-in column "cnt_t_total_actions" which counts bets calls checks folds and raises.

and we have the build-in column "cnt_f_check_raise" which makes a SUM: sum(if[holdem_hand_player_statistics.flg_f_check_raise, 1, 0])

How do I combine these 2 in best way?

I cant just make a new column and say: cnt_t_total_actions + cnt_f_check_raise because this would result in: x+1

Do I have to do this?:
sum(if[holdem_hand_player_statistics.flg_f_check_raise, cnt_t_total_actions , 0])

or doenst it validate so I have to make this?:

cnt_t_total_actions
sum(if[holdem_hand_player_statistics.flg_f_check_raise, bets +calls +checks +folds +raises, 0])


EDIT: TESTED BOTH: FAIL VALIDATION. So: How do I combine the 2 mentioned above?

I tried
c/r AND (bet OR fold OR raise OR check OR call) but flg_t_call doenst exist

maybe I could do it like this: c/r Flop AND saw turn flag? That should catch all or?

[js2002]

sum(if[lookup_actions_f.action LIKE 'XR' AND holdem_hand_player_statistics.flg_t_bet,1,0])
________
sum(if[lookup_actions_f.action LIKE 'XR'
AND holdem_hand_player_detail.flg_t_open_opp ,1,0])

ok?

[WhiteRider]

That looks good, but will only count hands where the player's flop action is to exactly check/raise, with no further action.
If you want account all hands where they check raise (and possibly face a re-raise) then you need to use:

lookup_actions_f.action LIKE 'XR%'

Of course, you may not want to count those hands.

[js2002]

Thx 4 that open eye!
without %s is ok! nevertheless 4 see more than 2 eyes :)

[kraada]

nevertheless 4 see more than 2 eyes :)

And that's why I wear glasses ;)