Some stats needed

[ZeDawning]

It still gives the same error msg

[kraada]

You were also missing one other bit, added in bold. I have double checked this validates:
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and cash_hand_player_statistics.flg_p_3bet AND ((cash_hand_summary.cnt_players BETWEEN 4 and 6 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 3 and 5) OR (cash_hand_summary.cnt_players BETWEEN 7 and 8 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 4 and 7) OR (cash_hand_summary.cnt_players BETWEEN 9 and 10 and substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 5 and 7 AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position)), 1, 0])

[ZeDawning]

It seems to be working. Thanks man Just have to test and see if it gives the correct numbers.

You can replace the entire thing there isn't a different CO depending on the number of players at the table. Like so:
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and cash_hand_player_statistics.flg_p_3bet AND substring(cash_hand_summary.str_aggressors_p from 2 for 1) = '1' AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position, 1, 0])

Shouldn't it be < ? As Ive done so for all others for oop?

[ZeDawning]

Alright tested it. Some worked, some didnt. (I checked it against the 3bet matrix I had)

Figures tallied for
3bipvsco
3boopvsco
3boopvsbu

Figures didnt tally for
3bipvsep
3boopvsep
3bipvsmp
3boopvsmp

Apparently Im getting the total figures i.e. 3B IP vs EP shows 115/6805 and 3B OOP vs EP shows 115/6805 whereas actual is 3B IP vs EP 78/4253 3B OOP vs EP 37/2552.
So I get the combined stat shown twice.
Similar case with MP.
Help pls.

[kraada]

The position of the raiser is less than our position if we are out of position.

How are you tallying?

[ZeDawning]

From 3bet matrix I add in MP+CO+BU 3bets vs EP to get 3betvsEP IP; SB+BB to get 3betvsEP OOP etc.

[ZeDawning]

1.Alright I fixed it I guess. Just copy pasted CO code, and used it on EP and MP (changed numbers to 3 and 2 and <> with regard to position). Numbers now tally correctly.
Is this alright?

Now the only thing left is
2. 4Bet vs Hero

Im pretty sure this is wrong but I simply swapped 3bet vs hero to 4bet. I think "hero.flg_p_first_raise" will not apply to 4bet. Any help on this would be appreciated!

(cnt_p_4bet_vs_hero / cnt_p_4bet_opp_vs_hero) * 100

cnt_p_4bet_vs_hero
sum(if[cash_hand_player_statistics.flg_p_4bet and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and hero.flg_p_first_raise), 1, 0])

cnt_p_4bet_opp_vs_hero
sum(if[cash_hand_player_statistics.flg_p_4bet and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and hero.flg_p_first_raise), 1, 0])

[kraada]

You want to change hero.flg_p_first_raise to hero.flg_p_3bet -- I presume you want 4bets when the hero made the 3bet.

[ZeDawning]

It works Thanks kraada!