Possible to get 2 stats made?

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: Possible to get 2 stats made?

Postby WhiteRider » Sat Feb 02, 2013 10:36 am

In most cases that should be all you need to do, although if you're using effective stack sizes they are different.
If you post your expression here we'll take a look at it for you.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Possible to get 2 stats made?

Postby jpeter9 » Sat Feb 02, 2013 6:36 pm

This is what I was entering into the expression field for a new column:

sum(if[cash_hand_player_statistics.cnt_t_raise > 0 and cash_hand_player_detail.flg_has_position_t
and cash_hand_player_detail.flg_r_open_opp, 1, 0])


Only tried the first one, and it would not validate.
jpeter9
 
Posts: 6
Joined: Thu Dec 03, 2009 3:33 am

Re: Possible to get 2 stats made?

Postby WhiteRider » Sun Feb 03, 2013 7:03 am

The table "cash_hand_player_detail" no longer exists - its contents have been merged into "cash_hand_player_statistics" in PT4.
Most of the field names are still the same, but in this case the "has position" field name has changed too.

This is what you need:

sum(if[cash_hand_player_statistics.cnt_t_raise > 0 and cash_hand_player_statistics.flg_t_has_position and cash_hand_player_statistics.flg_r_open_opp, 1, 0])

If you're not sure exactly what field to use click the blue Insert link to browse the database fields - that should often let you find the field you want.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Previous

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

Who is online

Users browsing this forum: No registered users and 12 guests

cron
highfalutin