Stats 3bet IP & OOP

[paradigm24]

Thank you for the help Krada. When I attempt to create the columns for the IP stats I am told that it is not a valid expression. I've attempted to figure out what the problem is, but the expression is more advanced than I'm familiar with. Thanks.

[kraada]

I misplaced a parenthesis.

The following will validate (and I'll fix the earlier post as well).

cnt_p_3bet_ip: 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):: int > cash_hand_player_statistics.position, 1, 0])

cnt_p_3bet_ip_opp:
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and
cash_hand_player_statistics.flg_p_3bet_opp and substring(cash_hand_summary.str_aggressors_p from 2 for 1):: int > cash_hand_player_statistics.position, 1, 0])

and

cnt_p_3bet_oop: 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):: int < cash_hand_player_statistics.position, 1, 0])

cnt_p_3bet_oop_opp:
sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 2 and
cash_hand_player_statistics.flg_p_3bet_opp and substring(cash_hand_summary.str_aggressors_p from 2 for 1):: int < cash_hand_player_statistics.position, 1, 0])

[dan4qa]

When I try again I have same message (Invalid Value Expression)?

[kraada]

That definition is for a column - take that expression and put it in a column (switch to the columns page), then use the columns to build the value expression of the stat you want - take a look at an existing stat or two, the test names you see there are references to the columns which you can see on the Columns page.

[dan4qa]

That definition is for a column - take that expression and put it in a column (switch to the columns page), then use the columns to build the value expression of the stat you want - take a look at an existing stat or two, the test names you see there are references to the columns which you can see on the Columns page.

Sorry but I have some trouble. What I did:
First

Second

Result


Whats wrong?

p.s. Please build this stats and attach file for the import.

[dan4qa]

Still wait for answer...

[kraada]

I'm not at my normal machine at the moment but as soon as I am, I will gladly build and attach that stat to this thread for you.

[dan4qa]

I'm not at my normal machine at the moment but as soon as I am, I will gladly build and attach that stat to this thread for you.

p.s. if it's not hard to you please make a stat Call 3bet IP & Call 3Bet OOP

[dan4qa]

I'm not at my normal machine at the moment but as soon as I am, I will gladly build and attach that stat to this thread for you.

p.s. if it's not hard to you please make a stat Call 3bet IP & Call 3Bet OOP

Just notice...
p.s. Still wait...

[dan4qa]

Is it some problem? With this stats?