Reports, facings, opportunities and averages

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

Reports, facings, opportunities and averages

Postby merkur33 » Sat Feb 07, 2009 7:48 pm

I want do make some reports which show me the averages of some stats under certain circumstances (e.g. ftp 2-table-turbo tourneys between 12 and 4 PM on working days ;) ). For a stat like raise flop CBet or fold to pf 3bet i need a certain number of opportunities or facings, to have a reliable denominator. Just looking for people with more than xxx hands doesn't really work, because one guy needs 100 Hands to get raised 10 times on the flop, and the other needs 500. Can i by some stat magic create stats, that don't show a number, if the denomitator is below xx? And by this way filter out these values when creating averages in the report? Or do i have to do a single report for each stat with an appropriate column filter?
merkur33
 
Posts: 126
Joined: Tue Nov 25, 2008 11:57 am

Re: Reports, facings, opportunities and averages

Postby WhiteRider » Sun Feb 08, 2009 6:34 am

You can do this using an IF statement in the Format Expression of your stat.
This sort of thing is explained in Kraada's excellent How To: Advanced HUD Configuration - actually, in this post in the same thread.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Reports, facings, opportunities and averages

Postby merkur33 » Sun Feb 08, 2009 10:57 am

Does this work also together with report summaries? Meaning, while computing the averages, the "non-values" (where the denominator is below xx) wouldn't count?
merkur33
 
Posts: 126
Joined: Tue Nov 25, 2008 11:57 am

Re: Reports, facings, opportunities and averages

Postby kraada » Sun Feb 08, 2009 11:20 am

You'd need to put the statement in the Format Summary Expression but then it should work for the summary as well.
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 9 guests