How to get player pool average stats?

[wangtangkiki]

I asked this for PT3 in November, and now I need it again, but I'm using PT4 lol :P

So how can I see the avg stats of all villains at a certain stake?
Will I be able to use regular filters like I want to have it filter for villains over 1k hands.

Thanks.

[kraada]

You want to use the My Reports tab for this. Create a new Player report grouped by Stake adding the default stats. Add the other stats you want to see (you can remove any you don't want to see also just leave the Stake grouping stat) then click the blue Filters link. Uncheck Filter on Active Player and add:
#Hands# > 1000

Now you'll get data from all players who have more than 1000 hands and each row will be for a different stake.

To exclude hands you've played add a second filter in the blue filters link:

player.id_player NOT IN (SELECT chpd.id_player from cash_hand_player_detail chpd where flg_hero)