Stat "Set %"

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: Stat "Set %"

Postby euneva » Sat May 08, 2010 12:56 pm

is this correct:

sum(if[holdem_hand_player_statistics.flg_f_saw AND
(holdem_hand_player_combinations.flg_f_threeoak OR holdem_hand_player_combinations.flg_f_fouroak OR
(holdem_hand_player_combinations.flg_f_fullhouse AND holdem_hand_player_combinations.id_f_hand_strength >= 6))...
euneva
 
Posts: 33
Joined: Thu May 15, 2008 5:41 pm

Re: Stat "Set %"

Postby kraada » Sat May 08, 2010 1:33 pm

Yup, that would do it.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stat "Set %"

Postby betzebub » Wed May 02, 2012 10:27 am

kraada wrote:There's a report in the repository that should have flopped set percentage; once you have the stat from there you can use it elsewhere - unless that's the one that wasn't working for you?


The download in the repository doesn´t work. Can you help?
betzebub
 
Posts: 34
Joined: Sun Mar 08, 2009 8:35 am

Re: Stat "Set %"

Postby kraada » Wed May 02, 2012 12:08 pm

What happens when you try to import it?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stat "Set %"

Postby betzebub » Thu May 03, 2012 11:34 am

kraada wrote:What happens when you try to import it?


Oh sorry. The stat works well.

I meant the report "Flopped Sets by alonalbert Apr. 16, 2008" doesn´t work. If I use the download i get the error "page was not found".
betzebub
 
Posts: 34
Joined: Sun Mar 08, 2009 8:35 am

Re: Stat "Set %"

Postby WhiteRider » Fri May 04, 2012 3:34 am

Thanks - we'll check it out and see what is going on with that report.
WhiteRider
Moderator
 
Posts: 54025
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 1 guest