report question

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 question

Postby hugblue » Thu Sep 29, 2011 11:40 pm

when i play and have my hud on. i see the game stats as it is right now.

lets say i wanted to make an report showing vpip/pfr/af
but that i only want the report to show it for the game i were playing right now.
and only with the players currently at my table as of now.

is this possible ??

thz//hugblue
hugblue
 
Posts: 10
Joined: Thu Sep 29, 2011 11:24 pm

Re: report question

Postby WhiteRider » Fri Sep 30, 2011 3:59 am

I think the attached report should be what you want.
You will need to extract the file from the .zip and import it to the Holdem > Cash Games > Reports tab, and then run it. This will show you player stats from sessions with a hand played in the last 2 minutes. If you want to change that time click on the blue Filters link. The report will only show stats from hands in the current session, not the overall stats for each player, which I think is what you want?

Active Players Current Stats.zip
(2.18 KiB) Downloaded 207 times


Tutorial: Custom Reports and Statistics
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: report question

Postby hugblue » Fri Sep 30, 2011 6:26 am

thz alot whiterider ..

is it possible to use this report in tournament too ???

//hugblue
hugblue
 
Posts: 10
Joined: Thu Sep 29, 2011 11:24 pm

Re: report question

Postby WhiteRider » Fri Sep 30, 2011 6:31 am

You can't use that exact report for tournaments, but a similar thing should work, yes. You will need to recreate the report in the Holdem Tournament Player Statistics section.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: report question

Postby hugblue » Fri Sep 30, 2011 6:42 am

hi whiterider ..

when you create a report like this.
then i suppose you first choose all the stats that should be shown.
when you choose it only to show the stats from within 2 minutes .. are you using the filters only .. for that ??

i can see in filters. that u have used something like this #session end#.. where did you find this command ??

thz..
//hugblue
hugblue
 
Posts: 10
Joined: Thu Sep 29, 2011 11:24 pm

Re: report question

Postby WhiteRider » Fri Sep 30, 2011 8:26 am

"Session End" is a custom stat in the Holdem Cash Player Statistics section, and you will need an equivalent stat in the Holdem Tournament Player Statistics section for your report.
The holdem cash version uses a column with this expression:

datefix_fromutc[holdem_table_session_summary.date_end]

The equivalent tournament column will be:

datefix_fromutc[tourney_holdem_summary.date_end]

This is updated every time a hand is imported for a tournament, so filtering for it being in the last 2 minutes limits hands to those played in ongoing tournaments. You may want to extend the time a little since you can sometimes get long hands in later stages of tourneys.
That new stat should be all you need for your report, but I've attached a version of the report ready-made too.
Attachments
Active Players Tournament Stats.zip
(1.15 KiB) Downloaded 145 times
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: report question

Postby hugblue » Fri Sep 30, 2011 1:13 pm

hi WhiteRider ..

i just tried the new one for tournament. and is not sure if its working perfectly.
i have created the column .. this way :

called the column : date_session_start
input text into expression : datefix_fromutc[tourney_holdem_summary.date_end]

then i imported your tournament packed file and imported it.

then i run the report. but even if i am not playing. it shows the values. and i dont think that would be possible
without playing a game.

but in the same report type for cash. its working fine. or have not checked it at a table yet. but it shows no values when running the report without being connected to a table.

- - - -

another thing :
when date_session_start is made. how do i find and use that column when making a report. for me it seems that there are
no data or info to be found anywhere. can u plz tell me how u get that part to work..

thz.
hugblue
 
Posts: 10
Joined: Thu Sep 29, 2011 11:24 pm

Re: report question

Postby hugblue » Fri Sep 30, 2011 2:33 pm

continue from previous ..

is sitting at a tournament right now.
and the report is giving information for 399 people.. is not sure that is allowed at a 10 player table.. lol.. joking.

really hope u can help me with the rest of this little problem.
because is part of a much bigger project that have been running the last 1.5 years.

and damn it ghave been a pain in the *** .. smiling.

and thz for your help till now.. ;-)
hugblue
 
Posts: 10
Joined: Thu Sep 29, 2011 11:24 pm

Re: report question

Postby WhiteRider » Fri Sep 30, 2011 4:37 pm

I would suggest that you remove your own custom stat and then re-import my report and that will import the required custom stat too. I suspect that the problem will be with the way that your column is defined - it needs to have the Group By option ticked for the way that it is used in the report.
I tested my report and it seemed to be working OK, although I didn't test it extensively. If you continue to have problems please export your report and compress and attach the file to a Support ticket and include a link to this thread and I'll take a look at it.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: report question

Postby hugblue » Fri Sep 30, 2011 6:26 pm

is testing a cash game. and that works totally perfect.

have not further tested tournament.. will soon test it.

ohh. and need to ask u.. i can export the report to a excel. but is it possible to export to an txt file ???

and sorry for all the questions. but its so lovely to talk to one who really can help..
thz.
hugblue
 
Posts: 10
Joined: Thu Sep 29, 2011 11:24 pm

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests