Open Shove by Stack Size

[Melkien]

Hello! I've been trying to make an open shove stat like in CoffeeHud divided by stack size.

For the general stat Open Shoved Preflop, this works:

Code: Select all

(cnt_p_os / cnt_p_open_opp ) * 100

cnt_p_os = sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp AND amt_p_raise_made>=amt_p_effective_stack, 1, 0])

cnt_p_open_opp = sum(if[tourney_hand_player_statistics.flg_p_open_opp, 1, 0])


Yet, when I try to do it for, for example, 12-15bb, it doesn't work:

Code: Select all

(cnt_p_os_12_15bb / cnt_p_open_opp_12_15bb ) * 100

cnt_p_os_12_15bb = sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp AND amt_p_raise_made>=amt_p_effective_stack AND amt_p_effective_stack<15 AND amt_p_effective_stack>=12, 1, 0])

cnt_p_open_opp_12_15bb = sum(if[tourney_hand_player_statistics.flg_p_open_opp AND amt_p_effective_stack>=12 AND amt_p_effective_stack<15, 1, 0])


Any help is appreciated!

[kraada]

You need to specify the tables with your fields - that is, instead of amt_p_effective_stack use tourney_hand_player_statistics.amt_p_effective_stack.

Basically all of your additions that don't have tourney_hand_player_statistics. in front of them need that

[Melkien]

Thanks!!!

[Melkien]

I tried changing it but no result . I made it with all the Open Shoved stats and columns, for instance:

With Open Shoved Preflop 12-15bb:

Code: Select all

Stat -> Open Shoved Preflop 12-15bb: (cnt_p_os_12_15bb / cnt_p_open_opp_12_15bb ) * 100

Columns ->  cnt_p_os_12_15bb: sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.amt_p_raise_made>=tourney_hand_player_statistics.amt_p_effective_stack AND tourney_hand_player_statistics.amt_p_effective_stack<15 AND tourney_hand_player_statistics.amt_p_effective_stack>=12, 1, 0])

cnt_p_open_opp_12_15bb: sum(if[tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.amt_p_effective_stack>=12 AND tourney_hand_player_statistics.amt_p_effective_stack<15, 1, 0])



Thanks!

[WhiteRider]

What exactly isn't working?
Do the columns not validate or are you getting bad data?

I wouldn't expect it to matter, but try putting spaces around your comparison operators - the >= and < for example.
That will help legibility even if it isn't actually required.

[aramalho]

Hi, it doesn't validate: ''you cannot use multiple aggregate funcions in a single column''


By, the way. is it possible for you guys to add me moderators to add me on skype? I want to make a hourly rate $ offer for PT4 personal explanation. my skype is Aramalho20, thank you very much.

[Melkien]

Actually, it is validating in my PT4, but when I try it with the hud it shows no data at all.

[kraada]

armalho,

Are you creating two separate columns? That error implies you have multiple aggregates - like sum(), and given what you pasted here for the two separate columns each only has one sum().

melkien,

Are you seeing 0/0 constantly or are you not even seeing that populate?

[BillGatesIII]

You will not see any results because tourney_hand_player_statistics.amt_p_effective_stack is the effective stack in chips, not in big blinds.

Will this stat be for HU only?

[kraada]

Ah, good catch - divide tourney_hand_player_statistics.amt_p_effective_stack by tourney_blinds.amt_bb to convert it into big blinds.