The Tournament Director Forums

Main => Help Me => Topic started by: efdenny on May 26, 2014, 12:11:29 PM

Title: Average Playing Time?
Post by: efdenny on May 26, 2014, 12:11:29 PM

Is there a way to generate average playing time in the stats?

Title: Re: Average Playing Time?
Post by: Corey Cooper on May 27, 2014, 10:23:16 PM

Sure, set one of your Overall Score formulas to:

playingTime / buyins

Title: Re: Average Playing Time?
Post by: efdenny on May 29, 2014, 09:31:18 PM

Hmmm, maybe I'm missing something?  That results in an Overall Score of xx,xxx.xx

Title: Re: Average Playing Time?
Post by: Corey Cooper on May 29, 2014, 10:03:48 PM

Yeah, you're missing conversion to hours and/or minutes.  Or, probably you can say that *I* missed it.  :-)

Problem here is that the TD currently doesn't allow you to change the type of the value that the Overall Score(s) produce.  So it's going to be displayed as a number.  The Playing Time column displays as hours, minutes, and seconds (6h 14m 33s), but there's no way to tell the Stats that the Overall Score column should be treated as a time value.  So it's just going to display it has a number.

(playingTime / buyins) / 3600

Now it should display in "hours".  So, for example, one of my players had an Avg Playing Time of "14,106.5000".  Using the updated formula it becomes "3.9185", or 3.9 hours.

Not perfect, but better ... ?

Title: Re: Average Playing Time?
Post by: efdenny on May 29, 2014, 11:06:09 PM

OK, that makes sense... that'll work!