Amount won on days of the week

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

Amount won on days of the week

Postby drkarl » Sat Mar 03, 2012 8:29 am

Hi I was wondering if there is a way to display the amount won each day of the week. So the total amount won on Mondays, Saturday etc. You can display the winrate for those days but not the total amount won.

I want to check my personal belief that I win more on weekends but its difficult to tell with the winrate as I'm not sure of how many hands I've put in on those specific days.

Any help would be appreciated.
drkarl
 
Posts: 3
Joined: Sat Mar 03, 2012 8:23 am

Re: Amount won on days of the week

Postby WhiteRider » Sat Mar 03, 2012 1:14 pm

Try the attached report - that will group by day of the week, and you can add whatever stats you like to it.

Day of Week.zip
Extract the file from the .zip and import it on the Reports tab in PT3.
(1.3 KiB) Downloaded 201 times
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Amount won on days of the week

Postby drkarl » Sat Mar 03, 2012 2:39 pm

WhiteRider wrote:Try the attached report - that will group by day of the week, and you can add whatever stats you like to it.

Day of Week.zip


Thanks for putting this together. I ran it and it works for the holdem tab. Unfortunately I mainly play Omaha. Which I probably should have mentioned so sorry for that! How do I make it work for the omaha tab? I searched for the Date DOW stat buy couldn't find it on the omaha tab.
drkarl
 
Posts: 3
Joined: Sat Mar 03, 2012 8:23 am

Re: Amount won on days of the week

Postby WhiteRider » Sat Mar 03, 2012 6:02 pm

It's a custom stat so you'll need to convert it. In the Custom Stats window go to Holdem Cash Player Statistics and on the Statistics tab select that stat. Next to the "Convert To" button at the bottom set the type to Omaha Cash Player Statistics and click Convert To.
You can then use that stat in a similar report in the omaha section.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Amount won on days of the week

Postby drkarl » Sat Mar 03, 2012 8:57 pm

That was awesome. Thanks for your help, got everything I needed.
drkarl
 
Posts: 3
Joined: Sat Mar 03, 2012 8:23 am


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

Who is online

Users browsing this forum: No registered users and 0 guests