How to customize tournaments results to show date and time

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

How to customize tournaments results to show date and time

Postby jacobbigshow » Sat Jul 11, 2009 1:26 pm

I have a question, for cash tournaments you are able to see how you do on certain hours of the day, for example at 3PM you make $1,000, and 4PM you lost $500. Is there a way to set up reports to show how much money and ROI you make on certain days of the week and times during the day and how would you do so?
jacobbigshow
 
Posts: 18
Joined: Fri May 22, 2009 5:30 pm

Re: How to customize tournaments results to show date and time

Postby WhiteRider » Sat Jul 11, 2009 2:21 pm

The problem with this sort of thing is that tournaments play out over a while, so you don't really win money at any particular time like you do at cash tables.
That said, I built a stat to show the start time of a tournament with no date for a similar question a while ago.
If you import the attached statistic (extract it from the zip file first) you can add it to a custom report in the 'holdem tournament tournament' section and sort by it or filter by it you can see all the tournaments which start at the same time.
You could duplicate it and adapt it to show only the hour if you prefer.

Custom Statistics and Reports FAQ.
Attachments
Start Time HHMM.zip
(525 Bytes) Downloaded 109 times
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: How to customize tournaments results to show date and time

Postby jacobbigshow » Mon Aug 31, 2009 1:49 am

OK guys took me a wile to finally start to see if I can get this to work but when I import the file, it goes to the tournament screen, not the tournaments screen, so the data that shows is just a list of every single tournament, and I am trying to do this:
I play 4 times a day, so I want to change the stats so that it shows tournaments from 11-1:30, then 2:30-5 and so on. So it just has the total amount won in 4 columns it shows me, now the like thousand it shows me now.
jacobbigshow
 
Posts: 18
Joined: Fri May 22, 2009 5:30 pm

Re: How to customize tournaments results to show date and time

Postby WhiteRider » Mon Aug 31, 2009 4:51 am

Yes, that's right - you need to import and use this stat in the 'holdem tournament tournament' section (not "tournaments").
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