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 erdnase17 » Wed Jul 30, 2014 4:59 am
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.
-
erdnase17
-
- Posts: 227
- Joined: Wed Feb 15, 2012 10:07 am
by kraada » Wed Jul 30, 2014 7:47 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.
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: Amazonbot, Google [Bot] and 8 guests