2x first in

[aramalho]

Good evening Krada,

I've done some custom stats based on others available on the forum, but there's no clear information on this:
Goal:
Tournaments:
Minraise first in:

Open shove first in:

I'm just skilled enough to change position from 0 to,1,2,3, I hope you could help me building this stats, since the information available is very narrow.


For minraise first in, I tried to create a collumn that:
Minraise first in button:
cnt_p_minraise_firstin

Collumn:
cnt_p_minraise_firstin

sum(if[tourney_hand_player_statistics.val_p_raise_aggressor_pos=0 AND (tourney_hand_player_statistics.amt_p_raise_facing / tourney_blinds.amt_bb) <= 2.25, 1, 0])

This is clearly wrong, since PT4 is not accepting.

Could you please review,

Thank you so much in advance!

[kraada]

Just to be clear: are we looking for times someone made a minraise first in or faced a minraise from the person who was first in?

[aramalho]

We're looking for times someone made a minraise first in.

[kraada]

Then you don't want to be using amt_p_raise_facing - that's for the raise size that the player faced.

This gives you minraise first in:

sum(if[tourney_hand_player_statistics.flg_p_open_opp and tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.amt_p_raise_made = 2 * tourney_blinds.amt_bb, 1, 0])

[aramalho]

Ok, so I created a column and pasted that and it worked, however,

Column ( correct )

cnt_p_minraise_firstin

sum(if[tourney_hand_player_statistics.flg_p_open_opp and tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.amt_p_raise_made = 2 * tourney_blinds.amt_bb, 1, 0])

Stat ( wrong), what should I do in the stat?

cnt_p_minraise_firstin


Thank you for your time in advance!

[kraada]

I'm not certain what you are saying - are you saying the values aren't adding up for you?

[aramalho]

You gave me a built column and I apretiate for that, but you didn't give me the statistic that I need to build using that column, could you do that please?


As you can see if I build the stat just copy pasting the column it will give no opportunities..
stat:
http://gyazo.com/2924baa9f7e9a21dc3aaaf0bb4540afb
column:
http://gyazo.com/b63b2a9f0089ab8761bb72d00a8103b3

gif:
http://gyazo.com/8b08c367e532ed82c78f5fbd497a5cc3

Thank you !!

[kraada]

You don't need a custom column for the opportunities - any time you have a chance to open you have a chance to open the minimum - so you can use the default column cnt_p_open_opp as your denominator.

[aramalho]

Hello Kraada, sorry for being so rookie at this, you're probably losing your nerves atm.

it is still not working!


http://gyazo.com/bd83fd3ff039e61414a5df8c949bff17

[WhiteRider]

Double check that you have the column name exactly right, and try putting spaces around the division / sign.