Day of Week Stats

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

Day of Week Stats

Postby PJs Ronin » Sun Jun 26, 2011 10:59 pm

I've checked the repository with no joy.

I have a feeling that certain days of the week are not good for me... eg, I always seem to get pounded on my Sundays but on my Thursdays life is pretty good. Is there a report that (for cash only) summarizes player stats (read win/loss) by dayofweek?
PJs Ronin
 
Posts: 978
Joined: Fri Dec 25, 2009 11:55 pm

Re: Day of Week Stats

Postby PJs Ronin » Tue Jun 28, 2011 7:44 pm

anyone home?
PJs Ronin
 
Posts: 978
Joined: Fri Dec 25, 2009 11:55 pm

Re: Day of Week Stats

Postby kraada » Wed Jun 29, 2011 9:51 am

I was away on vacation for a couple of days - I'm a bit surprised nobody got back to you before now.

Regardless: If you go to the Sessions tab you can choose Sessions - Details from the drop down and that will show you results summarized by day of the week.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Day of Week Stats

Postby PJs Ronin » Wed Jun 29, 2011 8:38 pm

tx kraada... I knew it would be something simple. Unfortunately, the results were not as I expected. I noticed that the upper panel is BB/100 hands, which in the example I have highlighted is green (I assume, 'good') and yet the bottom panel shows a red (loss) amount. I play a range of limits so I'm guessing that would account for the discrepancy.

I always like things to add up, I'm so used to 2 + 2 always being 4, so this seems a strange report to me. Is it possible to replicate the report so that the upper panel would make better sense, say $/100 hands?

[ img ]
PJs Ronin
 
Posts: 978
Joined: Fri Dec 25, 2009 11:55 pm

Re: Day of Week Stats

Postby kraada » Thu Jun 30, 2011 8:43 am

I'll pass this suggestion on - you can add BB/100 though by clicking the small configure icon (the little wrench) at the top right of the report, then double clicking BB/100 from the list on the left.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 0 guests