Total Aggression Factor

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

Total Aggression Factor

Postby winneronline » Sun Aug 03, 2008 7:26 am

Hey,

I read in another post pf yours that : "This is the formula PT3 uses to create the 'Total AF' statistic: (cnt_f_bet + cnt_f_raise + cnt_t_bet + cnt_t_raise + cnt_r_bet + cnt_r_raise) / (cnt_f_call + cnt_t_call + cnt_r_call)"
My problem is that i can't locate the cnt_f_bet,cnt_t_bet,cnt_r_bet in holdem_hand_player_statistics table in the DB. Are these stats equal to the flg_f_bet,... ?
winneronline
 
Posts: 11
Joined: Fri Jan 25, 2008 3:44 pm

Re: Total Aggression Factor

Postby WhiteRider » Sun Aug 03, 2008 8:35 am

The cnt_f_bet values are Columns, not DB fields.
Open the configure stats window (Configure -> Configure Stats) and select 'holdem cash player statistics' section.
Click 'Statistics' and choose 'Total AF' to see how the stat is built.
Then click 'Columns' and choose 'cnt_f_bet' to see how that is built.
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 11 guests