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.

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 ...

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.

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.

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?

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 ...

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.

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

Thanks.

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.

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...