Custom Stats: Averages (e.g. average PFR)

[BigFredy]

Hi,

i would like to create a stat that show e.g. the average PFR (all players, without hero).
How can i create such an average?

[kraada]

The easiest way to do this is to create a report on the My Reports tab. Make your report an All Players report, and include this Filter Expression:

player.id_player NOT IN (select distinct chps.id_player from cash_hand_player_statistics chps where chps.flg_hero)

Then look at the bottom row of the report - those are averages and you yourself are not included. Thus you'll see the average PFR there (I'm pretty sure PFR is included in the default All Players report - if not you can add it or any other stat you're curious about).

[BigFredy]

But i would love to have this value on my hud.
My goal ist, to use this average value to calculate an estimator for stats with a small sample size.

[kraada]

You can add another filter expression for:

#Hands# < 100

and then see only data taken from players with less than 100 hands.

If you want to see the table average though that's something else - you can add a HUD Table Group and set it to display Table Averages and anything you put in there (VPIP, PFR, etc) shows as the average of all of the players around the table who aren't you (and it's not weighted, so everyone counts equally).

[BigFredy]

For my needs i try to get the average (e.g. PFR) of all of the players in my Database at a certain Limit and thand take this value and combine it with the PFR from a specifig player. Than i have a more realable estimation for stats with a smal sample size (<50).

At the moment i get this average values from the report and than i calculate with a custom stats the estimators. But i have to update these Stats periodically. It would be nice if i could calculate the mean using some sql function.