Custom Stats not available in HUD

[Lythande71]

Everything has been sorted out and works absolutely smoothly.

There has never been any problems with the blind level stuff. So this works as described above.
All problems came from my self customized fields that I added manually to a system table!

Kudos to all guys from support team

It's remarkable that you guys continued supporting me although I altered the table in a way that usually leads to loss of any kind of support!

[kraada]

I'm glad to hear you got everything working

[m2510k]

created new columns in Holdem Tournament player statistics:

[1] cnt_hands_lbp: sum(if[tourney_holdem_hand_player_statistics.id_hand > 0 and tourney_holdem_blinds.amt_bb <=60, 1, 0]) Desc: "Number of hands played in low blind phase."
[2] cnt_vpip_lbp: sum(if[tourney_holdem_hand_player_statistics.flg_vpip and tourney_holdem_blinds.amt_bb <=60, 1, 0]) Desc: "Number of times player voluntarily put money in the pot in low blind phase."

Quick question: how would these lines look like for medium and for high blind phase? Thanks.

[WhiteRider]

Change:

tourney_holdem_blinds.amt_bb <=60

..for something like:

tourney_holdem_blinds.amt_bb > 60 AND tourney_holdem_blinds.amt_bb <= 300

[1] cnt_hands_lbp: sum(if[tourney_holdem_hand_player_statistics.id_hand > 0 and tourney_holdem_blinds.amt_bb > 60 AND tourney_holdem_blinds.amt_bb <= 300, 1, 0]) Desc: "Number of hands played in low blind phase."
[2] cnt_vpip_lbp: sum(if[tourney_holdem_hand_player_statistics.flg_vpip and tourney_holdem_blinds.amt_bb > 60 AND tourney_holdem_blinds.amt_bb <= 300, 1, 0]) Desc: "Number of times player voluntarily put money in the pot in low blind phase."

[m2510k]

Thanks. I created VPIP stats for low, med and high blind levels by copy-pasting appropriate lines into expression boxes (cnt_hands and cnt_vpip columns and then the VPIP stats according to formula (cnt_vpip/cnt_hands)*100 for each level). Summary type is set to Count Unique. Then I tested all three VPIP stats in HUD, but the numbers I get are wrong. For example, I have a player with 1264 hands on him, and when I drag over these new stats I get something like this in the pupop box:

VPIP for LOW: "Value: 14.235500 (81/569)"
VPIP for MED: "Value: 15.229400 (166/1090)"
VPIP for HIGH: "Value: 15.427200 (195/1264)"

According to my PT3 data on this player the stats should be calculated as:

VPIP for LOW: 13,9 over 586 hands
VPIP for MED: 16,4 over 533 hands
VPIP for HIGH: 17,0 over 186 hands

I have no prior experience with custom stats so I hardly know what I'm doing If you have an idea where I went wrong your help would be greately appreciated.

P.S. Since I had to put something into expression for high blind level cnt_vpip and cnt_hands columns, I put "AND tourney_holdem_blinds.amt_bb <= 1000" since all turbo Fifty50 tourneys finish before this level anyway. Is that ok?

[WhiteRider]

Since I had to put something into expression for high blind level cnt_vpip and cnt_hands columns, I put "AND tourney_holdem_blinds.amt_bb <= 1000" since all turbo Fifty50 tourneys finish before this level anyway. Is that ok?

That's okay, but will count all hands where you had less than 1000 BB. If you want a range you'll need to use something like:

AND tourney_holdem_blinds.amt_bb > 50 AND tourney_holdem_blinds.amt_bb <= 1000

(or whatever you want your ranges to be)