avg number of hands per tournament

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

avg number of hands per tournament

Postby 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

Re: avg number of hands per tournament

Postby 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]

Who is online

Users browsing this forum: No registered users and 9 guests

cron