HUD sample filter

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

HUD sample filter

Postby Happyprinc » Tue Mar 27, 2012 5:36 pm

It is possible to make a stat that will filter the sample size. For example, VPIP> 100 or show NA or nothing. I tried (cnt_vpip / cnt_hands) * 100 AND cnt_hands > 100 but doesnt work.
Happyprinc
 
Posts: 13
Joined: Sun Oct 03, 2010 6:26 pm

Re: HUD sample filter

Postby kraada » Tue Mar 27, 2012 6:05 pm

You can't add a filter like that - what you need to do is change the format expression to only display when a certain criteria is met.

For example:

if(cnt_hands > 100, format_number((cnt_vpip / cnt_hands) * 100, 0, false, false, '')

would do it. Please see this tutorial for further explanation on how to work with these expressions.
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 1 guest