3 bet shove % preflop

[minotaurs]

i tryed to make this stat but looks like i did something wrong

1. i created 3bet_opp_17_25 <--------- 3 bet opportunity column

sum(if[tourney_hand_player_statistics.flg_p_3bet_opp AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 17 AND 25
, 1, 0])

2. i created 3bet_shove_preflop_17_25 <-------------- actual 3 bet shove count column (tryed to show that raise must be excatly that size what is effective stack)

sum(if[tourney_hand_player_statistics.flg_p_3bet AND
(tourney_hand_player_statistics.val_p_raise_made_pct = (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb)) AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 17 AND 25
, 1, 0])

3. created stat -> 3 bet shove preflop 17-25bb

((3bet_shove_preflop_17_25)/(3bet_opp_17_25))*100

But when some1 actually do 3 bet shove, than statistics show 0 all the time. What could be the problem?

[kraada]

Better is:

sum(if[tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_player_statistics.enum_allin = 'P' AND lookup_actions_p.action = 'R' AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 17 AND 25
, 1, 0])

This checks that you did raise all-in and that you only made exactly one action - raise. If you only made one raising action and were all in it had to be a single shove.

[minotaurs]

I changed it like u said but it still shows just 0 if this action has happened

now it look like this

sum(if[tourney_hand_player_statistics.flg_p_3bet AND tourney_hand_player_statistics.enum_allin = 'P' AND lookup_actions_p.action = 'R' AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 17 AND 25
, 1, 0])

i didnt change 1st column

[kraada]

Can you paste a sample hand here that you think should be detecting an instance that is not?

[minotaurs]

Didnt work yesterday,I dont know how but it actually do work today, so tnx =]

[kraada]

That works :)