custom stats

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

custom stats

Postby raph156 » Thu Sep 01, 2011 10:02 am

Hi,
i would like, if resulte of stats " %win" > 50 then 1 on the hud and tab summary. Possible?
Tx for help
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: custom stats

Postby kraada » Thu Sep 01, 2011 10:17 am

Yes you could certainly build that statistic you wanted - you could do it using the advanced format options explained in this post.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: custom stats

Postby raph156 » Thu Sep 01, 2011 1:12 pm

yes, i have it but not with 2 steps.
exemple:
if <5 then 1, if >5 and <15 then 2, 0
i tryed:
if( win% <=5 , 1 ,if( win% >5 and win% <=15), 2, 0 )

Tx for help
raph156
 
Posts: 159
Joined: Tue Feb 09, 2010 3:22 pm

Re: custom stats

Postby kraada » Wed Sep 07, 2011 9:49 am

I think you may still need to have some kind of formatting for the "1" - using format_number() for example should work.
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 0 guests