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.
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?
- Posts: 227
- Joined: Wed Feb 15, 2012 10:07 am
Easiest is probably to make a duplicate version of the cnt_hands column with summary type Average. Use that in a new Hands stat and add that to any report that groups by tournament and then look at the summary line.
- Posts: 54435
- 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