call vs reshove customstat

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny

call vs reshove customstat

Postby dev209 » Sat Jul 28, 2018 2:04 pm

trying to build a stat which shows me how often SB (minraise) and calls against a reshove with effective Stacks between 16-20bb.

this is my code and i cant find my fault :/

Code: Select all
sum(if[tourney_hand_player_statistics.flg_p_open_opp
and tourney_hand_player_statistics.flg_p_first_raise
and tourney_hand_player_statistics.position = 9
AND tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb <= 2.25
AND tourney_hand_player_statistics.enum_p_3bet_action = 'C'
AND amt_p_3bet_facing / tourney_blinds.amt_bb >= 9
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 16 AND 20, 1, 0])
dev209
 
Posts: 179
Joined: Mon Jun 02, 2008 10:41 am

Re: call vs reshove customstat

Postby WhiteRider » Sat Jul 28, 2018 3:59 pm

In this line:

AND amt_p_3bet_facing / tourney_blinds.amt_bb >= 9

..you need to include the database table name, like this:

AND tourney_hand_player_statistics.amt_p_3bet_facing / tourney_blinds.amt_bb >= 9

Nothing else leaps out at me as being wrong there, so if it still doesn't work after this change (remember to rebuild the custom cache) please attach your stat to a Support Ticket along with a hand which should be counted but isn't (or isn't, but should be) and we'll take a look at it for you.
WhiteRider
Moderator
 
Posts: 53719
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: call vs reshove customstat

Postby dev209 » Sat Jul 28, 2018 4:42 pm

I test all my STats via My Reports and normally they work.

But when i test this one it says: "Expression is NOT valid!"

this is the exact code i test:

tourney_hand_player_statistics.flg_p_open_opp
and tourney_hand_player_statistics.flg_p_first_raise
and tourney_hand_player_statistics.position = 9
AND tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb <= 2.25
AND tourney_hand_player_statistics.enum_p_3bet_action = 'C'
AND tourney_hand_player_statistics.amt_p_3bet_facing / tourney_blinds.amt_bb >= 9
AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 16 AND 20



it also says that the Statement is not Valid when trying to build the columns, obviouly with sum(if[ .... , 1, 0])
dev209
 
Posts: 179
Joined: Mon Jun 02, 2008 10:41 am

Re: call vs reshove customstat

Postby WhiteRider » Sun Jul 29, 2018 5:16 am

I think it's just your formatting - when I add spaces and take out all of the line breaks that expression validates.

I haven't changed any of the text, and this validates for me:

tourney_hand_player_statistics.flg_p_open_opp and tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.position = 9 AND tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb <= 2.25 AND tourney_hand_player_statistics.enum_p_3bet_action = 'C' AND tourney_hand_player_statistics.amt_p_3bet_facing / tourney_blinds.amt_bb >= 9 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 16 AND 20
WhiteRider
Moderator
 
Posts: 53719
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: call vs reshove customstat

Postby dev209 » Sun Jul 29, 2018 7:03 am

thanks :oops:

organizing a better texteditor now
dev209
 
Posts: 179
Joined: Mon Jun 02, 2008 10:41 am

Re: call vs reshove customstat

Postby WhiteRider » Sun Jul 29, 2018 8:53 am

:geek:
WhiteRider
Moderator
 
Posts: 53719
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 3 guests

cron
highfalutin