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
by phonix4 » Wed Sep 02, 2009 10:11 pm
Can anyone tell me how to make a report selecting jst a few players. The only options i can find are single player and all player.
I wish to look in both Player vs and summary reports for the the players i'm currently playing so i can see if i generally win/lose against the players or if the player is generally a winner/loser. I know i can easily look through the lists at any time but it would be so much simpler if i could group the players together so i can look at them at the same time without having to trawl the lists everytime i forget. Any help is much appreciated. Thanx.
P.S. is there anyway i can get players Total recorded money won/lost and Total money won/lost Vs me displayed in the HUD this would save even more time.
-
phonix4
-
- Posts: 60
- Joined: Wed Sep 02, 2009 9:57 pm
by WhiteRider » Thu Sep 03, 2009 5:10 am
If you apply a date filter for the current date then it will show just the players active today - it's not quite current session only, but it will narrow things down for you a lot.
To see your opponents' overall win/loss just add the "Amount Won" stat to the HUD config. (EDIT: sorry, I just saw "vs me" - you can't do that in the HUD I'm afraid.)
See the HUD Guides in the
Documentation.
Tutorial: Managing HUD Groups
-
WhiteRider
- Moderator
-
- Posts: 54025
- Joined: Sat Jan 19, 2008 7:06 pm
- Location: UK
by phonix4 » Thu Sep 03, 2009 7:01 am
Thankyou whiterider i will give it a go. May get stuck on the date filter though.
If anybody reading this works for PT3 may i suggest adding a way of viewing numerous individuals rather than all or one as it saves so much time if you jst want to look at a specific group of players especially since there are so many one time wonders in poker that quite often you're left with a hardcore group of regulars that become you're main focus in the stats and individual finding in places such as players Vs and the summary groups is so time consuming. And if there could be a way of viewing the overall winnings/losses against the players in the HUD would be helpful as quite often i'm playing the same players and i like to not only beat the table but beat individual players that have beat me in the past.
Also if anybody could point me to some documentation that explains the stats and not jst the calculation i would be very grateful as i'm very new to stats and although i can get the jist of the stats i struggle to undertand and intepret them especially the things like aggression factor and such.
Thank you.
-
phonix4
-
- Posts: 60
- Joined: Wed Sep 02, 2009 9:57 pm
by phonix4 » Thu Sep 03, 2009 7:27 am
Ok The report i wish to have running is as follows.
Player/Amount Won/Hands/Hands Won/Win%.
I Think i've managed to get it working but it only brings me up unless i select fishlist. Could you tell me how to add the date filter. i found it but it's for a specific date i couldn't find Today's date or active players only or similar.
Could you also tell me how to actually get players rather than jst myself as this is all i get at the moment thank you.
I've jst noticed i can get the Amount won Stat and this works but is there a specific stat or way i can create my report to inlude players Amount Won Vs me as in the Player Vs tab. i think i've got it running for player selection but the Amount Won Vs me is the 1 i'm after thanx.
-
phonix4
-
- Posts: 60
- Joined: Wed Sep 02, 2009 9:57 pm
by phonix4 » Thu Sep 03, 2009 7:57 am
Ok i've finally got there my report is running smoothly now. Thank you whiterider. Still needs a way of letting you select the players you want to view but until this is available i can handle what i've got.
-
phonix4
-
- Posts: 60
- Joined: Wed Sep 02, 2009 9:57 pm
by kraada » Thu Sep 03, 2009 9:00 am
I'm glad to hear you got it working. We are planning to add several usability fixes in the near future and hopefully we can get this added as one of them.
-
kraada
- Moderator
-
- Posts: 54430
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests