Stats vs Hero

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Stats vs Hero

Postby fnopeaw » Wed Nov 07, 2012 3:51 am

This in PT4 ---> https://www.pokertracker.com/forums/vie ... 15&t=32041

Any chance to have this in HUD ? If not possible to have this info in HUD how do I proceed to make my report in PT4? Thanks !
fnopeaw
 
Posts: 124
Joined: Thu Mar 25, 2010 6:45 pm

Re: Stats vs Hero

Postby fnopeaw » Wed Nov 07, 2012 4:12 am

EDIT: https://www.pokertracker.com/blog/2012/ ... against-me I have already read this. My reason to use those stats are others which I won't discuss here. I just wanna be able to at least make the report I was able to do in PT3 :D
fnopeaw
 
Posts: 124
Joined: Thu Mar 25, 2010 6:45 pm

Re: Stats vs Hero

Postby kraada » Wed Nov 07, 2012 9:23 am

The PT3 style report to show you that data should work similarly in PT4. You can get to the filter expressions in PT4 by clicking the blue Filters link and then Edit Filter Expression - the same style of SQL expression will work there. If you'll give me the exact expression you had in PT3 I'll gladly give you the PT4 equivalent.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Stats vs Hero

Postby fnopeaw » Wed Nov 07, 2012 9:39 pm

This is the piece of code I'm trying to write in my report but it's giving me error.


holdem_hand_player_statistics.id_hand in (SELECT hhps.id_hand from holdem_hand_player_statistics hhps where hhps.id_player = (SELECT setting_value::int from settings where setting_name = 'my_player_id')
AND hhps.flg_p_first_raise AND hhps.flg_p_open_opp AND hhps.position = 0)
fnopeaw
 
Posts: 124
Joined: Thu Mar 25, 2010 6:45 pm

Re: Stats vs Hero

Postby kraada » Thu Nov 08, 2012 10:32 am

For PT4 you should change it to:

cash_hand_player_statistics.id_hand in (SELECT hhps.id_hand from cash_hand_player_statistics chps where chps.flg_hero
AND chps.flg_p_first_raise AND chps.flg_p_open_opp AND chps.position = 0)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 31 guests

cron