Multi table ratio

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

Multi table ratio

Postby Baldnbroke » Wed Aug 27, 2008 12:07 pm

I can't find the MT ratio anywhere, so I am trying to create it (please advice if it's already there somewhere).

cnt_minutes/cnt_minutes_real seems right, but I have to choose between

cnt_minutes_real_day
cnt_minutes_real_month
cnt_minutes_real_limit

I don't get why there are 3 of the real minutes variables?
Baldnbroke
 
Posts: 7
Joined: Tue May 20, 2008 4:38 pm

Re: Multi table ratio

Postby WhiteRider » Wed Aug 27, 2008 5:56 pm

MT Ratio is available on the Cash / Sessions tab if you choose 'Sessions by Time'.
I don't know what those cnt's are off the top of my head, but if you don't manage to work it out, bump this thread and I'll find out for you tomorrow (nearly bed time for me now).
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 1 guest