Help Manipulating Imported Stats

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

Help Manipulating Imported Stats

Postby evanski » Tue Sep 27, 2011 4:44 pm

I imported a stat from the repository, delayed cbet turn. It imports correctly, and appears to calculate correctly and do what I want it to. The stat can be found here: http://www.pokertracker.com/repository/statistics.php after searching for 'delay'. The value expression of this stat is:

(cnt_t_delay_cbet / cnt_t_delay_cbet_opp) * 100

Im attempting to create a second stat that references this, %fold to delay cbet. Ive never created stats before, but I read the guide and looked at the structure of the included stats. From this, I deduced that the stat I wanted should be formulated:

(cnt_f_fold_to_delay_cbet / cnt_f_fold_to_delay_cbet_opp) * 100

This does not work. Reducing further, the expression cnt_f_fold_to_delay_cbet is invalid. Why? What is the correct expression for this?
evanski
 
Posts: 33
Joined: Thu Aug 19, 2010 10:21 pm

Re: Help Manipulating Imported Stats

Postby kraada » Tue Sep 27, 2011 6:10 pm

The columns are merely references to items on the Columns tab - if you go to the Columns tab you can see the definition of cnt_t_delay_cbet and cnt_t_delay_cbet_opp - you'll want to create new columns that do what you need. Your names sound fine (as in you can use those names for the new columns) and the existing two columns should give you a clue as to how to start building them.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests