Page 1 of 1

wich stat

PostPosted: Fri Aug 26, 2011 3:16 pm
by skolnieks
wich stat shows bet% limped pots?

Re: wich stat

PostPosted: Fri Aug 26, 2011 3:32 pm
by kraada
That stat doesn't exist by default but you could build it using these column definitions:

cnt_f_bet_limp_pot: sum(if[holdem_hand_player_statistics.flg_f_bet and NOT(holdem_hand_player_statistics.flg_p_face_raise) and holdem_hand_player_statistics.cnt_p_raise = 0, 1, 0])

and

cnt_f_open_opp_limp_pot: sum(if[holdem_hand_player_detail.flg_f_open_opp and not(holdem_hand_player_statistics.flg_p_face_raise) and holdem_hand_player_statistics.cnt_p_raise = 0, 1, 0])

Put the former over the latter and multiply by 100 to get the stat.

Re: wich stat

PostPosted: Sat Aug 27, 2011 5:52 am
by skolnieks
kraada wrote:That stat doesn't exist by default but you could build it using these column definitions:

cnt_f_bet_limp_pot: sum(if[holdem_hand_player_statistics.flg_f_bet and NOT(holdem_hand_player_statistics.flg_p_face_raise) and holdem_hand_player_statistics.cnt_p_raise = 0, 1, 0])

and

cnt_f_open_opp_limp_pot: sum(if[holdem_hand_player_detail.flg_f_open_opp and not(holdem_hand_player_statistics.flg_p_face_raise) and holdem_hand_player_statistics.cnt_p_raise = 0, 1, 0])

Put the former over the latter and multiply by 100 to get the stat.


like so :

(cnt_f_open_opp_limp_pot*100) / cnt_f_bet_limp_pot

Re: wich stat

PostPosted: Sat Aug 27, 2011 6:21 am
by skolnieks
kraada wrote:That stat doesn't exist by default but you could build it using these column definitions:

cnt_f_bet_limp_pot: sum(if[holdem_hand_player_statistics.flg_f_bet and NOT(holdem_hand_player_statistics.flg_p_face_raise) and holdem_hand_player_statistics.cnt_p_raise = 0, 1, 0])

and

cnt_f_open_opp_limp_pot: sum(if[holdem_hand_player_detail.flg_f_open_opp and not(holdem_hand_player_statistics.flg_p_face_raise) and holdem_hand_player_statistics.cnt_p_raise = 0, 1, 0])

Put the former over the latter and multiply by 100 to get the stat.


that stat dont shows total opportunities when i move a coursor on the stat... is it becouse of what???
when i made i used format /%.2f is it correct???

Re: wich stat

PostPosted: Sat Aug 27, 2011 6:56 am
by WhiteRider
Your expression is mathematically correct, but for the HUD to show times/opportunities the Value Expression needs to be written like this:

(cnt_f_open_opp_limp_pot / cnt_f_bet_limp_pot) * 100

Re: wich stat

PostPosted: Sat Aug 27, 2011 11:09 am
by skolnieks
WhiteRider wrote:Your expression is mathematically correct, but for the HUD to show times/opportunities the Value Expression needs to be written like this:

(cnt_f_open_opp_limp_pot / cnt_f_bet_limp_pot) * 100


something is wrong... value of that stat is 100% for all players... no matter how many opportunities they have...

Re: wich stat

PostPosted: Sat Aug 27, 2011 11:19 am
by WhiteRider
The expressions look OK to me - are you sure you have the two separate expressions in the right columns?
If you export your stat, compress the .pt3stat file and attach it to a Support ticket I'll check it out for you if you can't see what is wrong with it.

Re: wich stat

PostPosted: Mon Aug 29, 2011 5:24 am
by skolnieks
WhiteRider wrote:The expressions look OK to me - are you sure you have the two separate expressions in the right columns?
If you export your stat, compress the .pt3stat file and attach it to a Support ticket I'll check it out for you if you can't see what is wrong with it.


i send that that to support... item id 112296... can u check that?

Re: wich stat

PostPosted: Mon Aug 29, 2011 10:02 am
by kraada
We'll take a look and get back to you in your ticket.