Tracking Leaderboard Points

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

Tracking Leaderboard Points

Postby PartyAnimal » Tue Jan 24, 2012 8:28 pm

I created a custom stat to track my tournament leaderboard points at PartyPoker. I created it in the "Single Tournament Details" [ sqrt(amt_buyin) / 2 + sqrt(amt_won) ] and it works fine in the Tournaments tab.

However, when I try to add in the Winnings tab, the single line for January 2012 in "Winnings By Month" suddenly becomes many lines. How can I see my leaderboard points for each month and each day without messing up the Winnings reports?
PartyAnimal
 
Posts: 98
Joined: Mon Jun 15, 2009 10:55 am

Re: Tracking Leaderboard Points

Postby WhiteRider » Wed Jan 25, 2012 4:06 am

If you display a stat for individual tournaments in a reports showing multiple tournament results on a single line it will break up that report. You would need to build a version of your stat in the Holdem Tournament Tournaments section using "sum" to total up the results over all tournaments.

Tutorial: Custom Reports and Statistics
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 0 guests