Search found 227 matches

Return to advanced search

avg number of hands per tournament

I would like to make a custom stat to show the avg number of hands per tournament.
I added the following column but it is not working as intended:
Code: Select all
avg(if[tourney_hand_player_statistics.id_hand > 0, 1, 0])


How can I define this stat?

Thanks.
by erdnase17
Wed Jul 30, 2014 4:59 am
 
Forum: Custom Stats, Reports, and SQL [Read Only]
Topic: avg number of hands per tournament
Replies: 1
Views: 23960

batch purge

I mistakenly imported some observed hands into my own playing database and I would like to purge these tournaments. Purging one by one using the UI is too tedious and slow as I imported dozens of tournaments. Is it possible to ask someone from the development team to give me a query I could execute ...
by erdnase17
Wed May 28, 2014 6:09 pm
 
Forum: PokerTracker 4
Topic: batch purge
Replies: 1
Views: 351

Re: v4.11.1 HUD proglem: "Unknown token encoutered"

Why there is no functionality for finding and replacing the names of columns. Since users can potentially create hundreds of custom stats this functionality is absolutely essential.
by erdnase17
Fri May 23, 2014 6:50 am
 
Forum: PokerTracker 4
Topic: v4.11.1 HUD proglem: "Unknown token encoutered"
Replies: 42
Views: 6667

SSD for postgres db only?

Can we achive any performance benefits of using an SSD forthe PT4 DB only, while keeping the OS and PS client still installed on the mechanical disk drive?

Thanks.
by erdnase17
Wed Mar 19, 2014 4:13 pm
 
Forum: PokerTracker 4
Topic: SSD for postgres db only?
Replies: 1
Views: 365

Re: Fixing incorrect statistic for HU SNGs

kraada wrote:I suspect this is due to the interaction between tournament level filters and hand level stats. Are any other stats also similarly affected?


I only noticed this stat was affected. Is there any workaround?
by erdnase17
Thu Mar 06, 2014 5:45 pm
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Fixing incorrect statistic for HU SNGs
Replies: 3
Views: 574

Fixing incorrect statistic for HU SNGs

I am looking at one statistic for VPIP OOP vs minr (where a minr is up to a 2.25bb raise). It is defined as: (cnt_p_vpip_facing_minraise_7_13 / cnt_p_call_opp_7_13) * 100 where cnt_p_call_opp_7_13 is defined as: sum(if[lookup_positions.flg_bb AND tourney_hand_player_statistics.amt_p_2bet_facing > 0 ...
by erdnase17
Thu Mar 06, 2014 11:54 am
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Fixing incorrect statistic for HU SNGs
Replies: 3
Views: 574

Re: Hand Report: group hands by tournament

I just duplicated the Tournament# stat for Hands. Now if I sort a hand report by Tournament# and then by Hand# I get what I what.
by erdnase17
Mon Feb 03, 2014 7:20 pm
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Hand Report: group hands by tournament
Replies: 1
Views: 338

Hand Report: group hands by tournament

Is it possible to group the hands in a hand report by tournament?

Thanks.
by erdnase17
Mon Feb 03, 2014 6:40 pm
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Hand Report: group hands by tournament
Replies: 1
Views: 338

Re: Show Avg Buy-In for Tournament graphs?

I noticed the latest PT4 update 4.10.7 has a new stat 'My Currency Avg Buy-In'.
However it differs from the one produced in this thread because it seems to not account for tournament fees.
Shouldn't this be documented in the description or in the stat title?

Thanks.
by erdnase17
Thu Jan 30, 2014 5:13 am
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Show Avg Buy-In for Tournament graphs?
Replies: 19
Views: 2812

Expression filter for opponent holecards in HU sngs?

I would like to make an expression filter for hand report where I could filter for the opponent holecards but I can't figure the appropriate SQL expression for this. When I make the hand report for hero and use id_holecard it refers to hero's holecards obviously, how can I refer to the opponent's ho...
by erdnase17
Thu Nov 28, 2013 8:05 am
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Expression filter for opponent holecards in HU sngs?
Replies: 1
Views: 413
Next

Return to advanced search

cron
highfalutin