Need Help for Custom Report using months & weeks (Group by)

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

Need Help for Custom Report using months & weeks (Group by)

Postby WestEarn » Mon Mar 19, 2012 10:50 am

Hello,

I'm a beginner on PT3.

I 'm starting to create the personal reports I need.

I would like to create personal reports displaying totals and average earnings, BB/100, bb/hour, €/hour, using group by the month, like January 2012, Feb 2012, March 2012, etc., on line for one month . ...

And also I need these reports with group by the week, one line for one week, as 2012 Week01, 2012 Week02, 2012 Week03, etc.. ...

I would also derive the corresponding graphics.

I have some knowledge in SQL, but none about the variables and stats in PT3.
I am completely disappointed, and lost on pt3. :mrgreen:

Could you help me please?

Thanks

from France
WestEarn
 
Posts: 94
Joined: Mon Mar 19, 2012 10:08 am

Re: Need Help for Custom Report using months & weeks (Group

Postby kraada » Mon Mar 19, 2012 12:36 pm

There's a grouping by week stat available in the repository - it's called Weekly Breakdown, and was uploaded by me. You'll need to convert it to tournaments but that is a lot easier than building it from scratch :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need Help for Custom Report using months & weeks (Group

Postby WestEarn » Mon Mar 19, 2012 2:01 pm

Hello.

Thanks. Exactly what I need. Great.

I've copy/paste the statistic from tournament to Cash Game sessions summary. I've met some difficulties because I see later that I had to create the column date_played_week in holdem_table_session_summary. Now it's ok.

An other trouble because I did not check the Group by parameter.

But great to have a solid base to do this, for the newbie I am on PT3. Thanks.

Just a question. Does this statistic consider the day starts parameter? This parameter is on 04AM for me. Will the reports take the hands past midnight of the current day? Does the break of Sunday (end of week) be at Monday 04AM (my real end of week), and not at Sunday midnight?

Thanks.
Sorry for my approximative English, I'm French.
WestEarn
 
Posts: 94
Joined: Mon Mar 19, 2012 10:08 am

Re: Need Help for Custom Report using months & weeks (Group

Postby kraada » Mon Mar 19, 2012 4:39 pm

It should take the my day starts at value into account, but it's been quite a while since I looked at the stat so I'm not 100% certain to be completely honest.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need Help for Custom Report using months & weeks (Group

Postby WestEarn » Mon Mar 19, 2012 6:40 pm

Thanks. I will test this point next Sunday.

Right now, I'm in trouble: about the hours cumuls in the new report by week. It add all tables seconds, not just the seconds of the sessions.

The seconds of all tables must not be added if the tables are played in the same session. Unfortunately, if I play 1 hour with 10 simultaneous tables, the report says I have played 10 hours! Not so easy for the newbie that I am with PT3! :mrgreen:
WestEarn
 
Posts: 94
Joined: Mon Mar 19, 2012 10:08 am

Re: Need Help for Custom Report using months & weeks (Group

Postby kraada » Tue Mar 20, 2012 7:55 am

That is expected behavior - in PT4 we have eliminated the "Sessions" stat type so all we have are player and hand stats - and player stats are summed over all hands you've played. This grouping stat groups just based on the time the hands were played - it can't tell whether there is session overlap. Unfortunately, due to the complexity behind grouping by time, I'm not sure there's a simple stat we can add that will fix that particular piece of behavior.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need Help for Custom Report using months & weeks (Group

Postby WestEarn » Tue Mar 20, 2012 10:42 am

In the sessions tab of cash game, set on Sessions By Time, PT3 does the job well: I've played 16 tables simultaneous from 08:53PM to 01:05AM and it says 253 minutes (4.22hours), not 253 x16 minutes... The second row is OK, the third row also... And the total at the feet of the report is good also: 6.5 hours is ok. PT3 has not done the error to add 16x4.22hours + 6x1.50hours + 5x0.78 hours.

So, it seems to be possible, isn't it? What could be the way?

Image

PS: what does the MTRatio mean?
WestEarn
 
Posts: 94
Joined: Mon Mar 19, 2012 10:08 am

Re: Need Help for Custom Report using months & weeks (Group

Postby kraada » Tue Mar 20, 2012 5:36 pm

These reports are built very differently in PT3 and PT4. I'll make a note to look into what we can do here but I can't guarantee that I'll find a way to make this work as you want.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Need Help for Custom Report using months & weeks (Group

Postby WestEarn » Tue Mar 20, 2012 7:14 pm

Thank you, it's very nice of you.

It is true that to know the real playing time compared to earnings is very useful to know its profitability.

Sincerely
WestEarn
 
Posts: 94
Joined: Mon Mar 19, 2012 10:08 am

Re: Need Help for Custom Report using months & weeks (Group

Postby WestEarn » Sun Mar 25, 2012 7:14 pm

kraada wrote:It should take the my day starts at value into account, but it's been quite a while since I looked at the stat so I'm not 100% certain to be completely honest.


It's OK, the report takes care of my day start parameter.

Perfect.

Thanks
WestEarn
 
Posts: 94
Joined: Mon Mar 19, 2012 10:08 am

Next

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

Who is online

Users browsing this forum: No registered users and 7 guests

cron
highfalutin