WWoSD %

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Re: WWoSD %

Postby WhiteRider » Wed Jan 11, 2012 4:31 am

For tournament columns you'll need to add "tourney_" to the start of the database field names. I'm surprised it let you build those columns in the Holdem Tournament Player Statistics section.

These should be OK:

cnt_won_wo_sd =
sum(if[not(tourney_holdem_hand_player_statistics.flg_showdown) and tourney_holdem_hand_player_statistics.flg_won_hand, 1, 0])

cnt_hands_wo_sd =
sum(if[not(tourney_holdem_hand_player_statistics.flg_showdown) and tourney_holdem_hand_player_statistics.flg_vpip, 1, 0])
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: WWoSD %

Postby yserman » Wed Jan 11, 2012 10:31 am

OK.I did like you say but there are some troubles yet...First is that the stat doesn't calculate the players on the BB(all players fold to BB but the stat doesn't change).The second problem is that stat after a while starts to decrease(for example it was 2 but after several hands played it is 0.Or it was 5 for one player but after one level blinds it is already 2 or something...).
Thats why the question is how to make a stat constant?And how to make BB also to be involed though the stat calculating?
Thanks in advance!
yserman
 
Posts: 14
Joined: Thu Nov 10, 2011 12:22 pm

Re: WWoSD %

Postby kraada » Wed Jan 11, 2012 10:42 am

With those definitions it should certainly be counting walks. Are you certain you don't have any other HUD filters (e.g. use stats from current blind level only or are using the Player Ranges options)? Those could cause some of the behavior you are describing - it would affect all stats in fact.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: WWoSD %

Postby yserman » Wed Jan 11, 2012 11:38 am

No i don't use filters or "payer range".The only filter is "Retrive Session Stats for tool tips".
p.s. other stats in my hud is changing/working great...The only trouble is in this stat.It's calculating through the formula,but after some hands dealed it begin to deacrease...
yserman
 
Posts: 14
Joined: Thu Nov 10, 2011 12:22 pm

Re: WWoSD %

Postby kraada » Wed Jan 11, 2012 11:52 am

Please export the stat, zip it up and attach it to a support ticket so that we can investigate for you what exactly is happening here.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 2 guests

cron