Customstat:Vpip of a player with less than 10bbs

[Maniac81]

Hi
I try to make a custom stat that shows the vpip of a player when he has less than 10bbs in a tournament. I read a little bit in the forums and i learned that i have to change the cnt_vpip column. I changed it to sum(if[tourney_holdem_hand_player_statistics.flg_vpip AND tourney_holdem_hand_player_detail.amt_before < (tourney_holdem_blinds.amt_bb * 10), 1, 0])
is this correct?
When i now look at the definition of the vpip stat i have to change the cnt_Hands column too to make the new stat right?
Then my cnt_hands code looks like this:
sum(if[tourney_holdem_hand_player_statistics.id_hand > 0 AND tourney_holdem_hand_player_detail.amt_before < (tourney_holdem_blinds.amt_bb * 10), 1, 0])
And then i go to the statistics tab and duplicate the vpip stat and replace the old columns with the new ones. is this the right approach?

[kraada]

That approach will do what you want yes.

[Maniac81]

thx for answer. I have one more question. If i want to my hud to show the PFR amount with >= 15bbs then is this the right formula for cnt_Pfr?
sum(if[tourney_holdem_hand_player_statistics.cnt_p_raise > 0 AND tourney_holdem_hand_player_detail.amt_before >= (tourney_holdem_blinds.amt_bb * 15), 1, 0])
I tested it with this column and my Hud shows nothing for the PFR. The filtering for vpip works fine.
edit: it works now after caching the database again.

[kraada]

Yep that will do it - each time you add a new column in PT3 you do need to update your cache. As a result it's to your benefit to do stats in batches if at all possible.