Report that shows ring game stats by hr and day of wk

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

Report that shows ring game stats by hr and day of wk

Postby mekter » Fri Nov 13, 2009 4:42 pm

does anyone have a report that generates ring game stats (bb/100) based on time and day of wk similar to pt2 in the sessions tab?
mekter
 
Posts: 25
Joined: Thu May 15, 2008 10:55 am

Re: Report that shows ring game stats by hr and day of wk

Postby kraada » Fri Nov 13, 2009 5:26 pm

If you go to the sessions tab you can choose Sessions - Details from the drop down at the top and that will show you your winrate broken down by day of the week and time of day.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report that shows ring game stats by hr and day of wk

Postby mekter » Fri Nov 13, 2009 6:10 pm

in pt2 yes, but what about PT3?
mekter
 
Posts: 25
Joined: Thu May 15, 2008 10:55 am

Re: Report that shows ring game stats by hr and day of wk

Postby kraada » Fri Nov 13, 2009 6:17 pm

That report is there in PT3 as well.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report that shows ring game stats by hr and day of wk

Postby Casey » Sat Nov 14, 2009 3:04 am

Thanks for pointing this out. That is an awesome report, for people like me that play at different times/days of the week.

Casey
Casey
 
Posts: 8
Joined: Wed Oct 21, 2009 1:08 am

Re: Report that shows ring game stats by hr and day of wk

Postby kraada » Sun Nov 15, 2009 9:44 am

Yes, yes it is :)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report that shows ring game stats by hr and day of wk

Postby BigKeeya » Sat Jan 23, 2010 9:16 am

I found the feature. However, my stats don't add up correctly in the column and row totals. I'd include a screenshot, but there is not upload button. Anyone else experience this?
BigKeeya
 
Posts: 4
Joined: Thu May 22, 2008 12:02 am

Re: Report that shows ring game stats by hr and day of wk

Postby kraada » Sat Jan 23, 2010 10:04 am

They aren't going to add up strictly because the number of hands played in two different cells may not be the same.

For example, take the monday column. Say you have two sessions worth one in the 1-2PM slot and one in the 7-8PM slot. In the 1-2PM slot you ran at 1ptbb/100 and in the other slot you ran at -1ptbb/100. That's not enough information to know the total Monday value - you need to know how many hands you played in each slot. If you played 100 hands from 1-2 and 200 hands from 7-8, you'd have won 1 - 2 or -1 ptbb in that day out of 300 hands so you'd have a daily winrate of -1/3 ptbb/100.

If you add up all the individual hands and winrates you'll see that the values work out properly.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Report that shows ring game stats by hr and day of wk

Postby BigKeeya » Sun Jan 24, 2010 4:20 pm

That makes sense, thank you.
BigKeeya
 
Posts: 4
Joined: Thu May 22, 2008 12:02 am

Re: Report that shows ring game stats by hr and day of wk

Postby kraada » Sun Jan 24, 2010 9:33 pm

No problem :)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests