AF HU?

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

AF HU?

Postby preparac » Sun Sep 05, 2010 2:40 pm

thanx
and is there a way to create a AF stat for headsup pots in the same way as AF in general is defined?
I do not geht how to combine
sum(tourney_holdem_hand_player_statistics.cnt_f_call)
with
AND tourney_holdem_hand_summary.cnt_players_f = 2
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am

Re: AF HU?

Postby WhiteRider » Sun Sep 05, 2010 2:53 pm

It sounds like you have the general idea - for each column that the AF stat uses you'll need to create a new one with the check for heads up.

In your example, you want:

SUM( IF[ tourney_holdem_hand_summary.cnt_players_f = 2, tourney_holdem_hand_player_statistics.cnt_f_call, 0 ] )

This says add up (SUM) the result of the IF statement for each hand.
The IF says if two players see the flop then add the number of calls, otherwise add zero.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: AF HU?

Postby preparac » Sun Sep 05, 2010 3:20 pm

ok, thank you vey much. The "if" must be written in small letters ...
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am

Re: AF HU?

Postby WhiteRider » Sun Sep 05, 2010 3:26 pm

Ha! I never knew that!! I guess I always use lowercase when I'm actually writing expressions for real...
Sorry about that. :oops:
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 0 guests