créate check fold flop

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

créate check fold flop

Postby STEAK8975 » Wed Dec 01, 2010 4:45 am

Hello
I want to créate the stat checkfold flop.Can you tell me if what i write is ok?
(cnt_f_check_fold / cnt_f_check_fold_opp) * 100
Thanks
Steak
STEAK8975
 
Posts: 5
Joined: Tue Jan 13, 2009 2:29 pm

Re: créate check fold flop

Postby WhiteRider » Wed Dec 01, 2010 5:16 am

That's fine, but you will need to define those columns too.

You could use expressions like these:

cnt_f_check_fold =
sum( if[ lookup_actions_f.action = 'XF', 1, 0 ] )

cnt_f_check_fold_opp =
sum( if[ lookup_actions_f.action LIKE 'X_%', 1, 0 ] )

See the Tutorial: Custom Reports and Statistics for help building your stat from these expressions.
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