Page 1 of 1

avg number of hands per tournament

PostPosted: Wed Jul 30, 2014 4:59 am
by erdnase17
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.

Re: avg number of hands per tournament

PostPosted: Wed Jul 30, 2014 7:47 am
by kraada
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.