Time/opportunities doesn't show - ?!

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

Time/opportunities doesn't show - ?!

Postby Hilips » Thu Feb 17, 2011 4:44 pm

I have created AGG % like in HEM, just because im used to it and already know what the numbers are for passive/aggro/etc. Yes i know how PT3 staff feels about Agg% vs AFq, but i have used HEM for years and i need some time to figure it out.

This is the AGG % Flop:

((cnt_f_bet + cnt_f_raise) * 100) / cnt_f_saw

I think this is right, i have compared the number betwen PT3 and HEM and they are the same.

The problem is i can't make it to show the time/opportunities, like 40% (3/7). The numbers betwen (), how can i do that? In the properties of the stat i already changed the Show times/oportunities to true but doesn't show any number anyway.

Help?

Btw, the cnt_f_raise include check raises too? I know there is a cnt_f_check_raise (or something) but if i add it to the formula the numbers don't match up with HEM agg%.

Tks
Hilips
 
Posts: 37
Joined: Thu Jan 24, 2008 8:06 pm

Re: Time/opportunities doesn't show - ?!

Postby kraada » Thu Feb 17, 2011 5:36 pm

Any raise counts as a cnt_f_raise, and each raise counts once.

To get times/opportunities working I think you need to restructure your expression like so:

((cnt_f_bet + cnt_f_raise) / cnt_f_saw) * 100

It shouldn't affect the mathematical value any.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Time/opportunities doesn't show - ?!

Postby Hilips » Thu Feb 17, 2011 5:48 pm

Tks man, that was it, working now. :)
Hilips
 
Posts: 37
Joined: Thu Jan 24, 2008 8:06 pm


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

Who is online

Users browsing this forum: No registered users and 0 guests