avg number of hands per tournament

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

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