% of hands won per amount of first-in raise (in bb)

[2005TS]

Hello, I'm trying to develop a pop-up group in HUD where I can see how each player is performing according to the amount they chose to raise first-in (in terms of bb).
So, Let's say that you sit on a NL with blinds $0.25-$0.5. So the bb=$0.5.

I have created the following column, where I need to find all hands where the player raised first-in and the amount was 2 times the big blind.

Code: Select all

cnt_rfi_2bb_all:
sum(if[holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_detail.amt_p_raise_made = 2 * holdem_limit.amt_bb,1,0])


Then I have created the following column, where I need to find all hands where the player raised first-in, won the hand and the amount was 2 times the big blind.

Code: Select all

cnt_rfi_2bb_won:
sum(if[holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_detail.amt_p_raise_made = 2 * holdem_limit.amt_bb,1,0])


then the statistic:

Code: Select all

(cnt_rfi_2bb_won / cnt_rfi_2bb_all) * 100

should show me the percentage I want. But something is wrong, because when someone makes this minraise the statistic remains as NA in the HUD.
Can you please provide some advise on what is wrong in these definitions?

Thanks

[kraada]

Those look like they should work just fine - did you update the cache after creating the new custom columns?

[2005TS]

Yes, it's fine now. Thanks

Can you please tell me if this stat is just for the current session? I don't think I can see a player's history on raising patterns (all hands played - even from previous sessions).
If yes, how i can transform this to include all previous hands?

[kraada]

For your opponents it should display lifetime data. Your stats on the table will always be session only so that you can see how others at the table think of your current play.