Analyse playerpool tendencies

[Cipi322]

Can someone explain to me how I could see the population tendencies on the HUD?
I mean like I am able to see it for me in the hand replayer.

Thank you!

[Flag_Hippo]

I am making a similar report, but would like to see opening ranges from different types of players, lags, tags ,etc. How could I do this, Thanks.

It depends on how you want to define lags, tags e.t.c but basically you need to substitute the columns and values you want in an expression filter like this:

Code: Select all

cash_hand_player_statistics.id_hand in (select chps.id_hand from cash_hand_player_statistics chps where chps.id_player in (select cc.id_player from cash_cache cc where true group by cc.id_player having ((sum(cc.cnt_vpip) * 1.0) / (sum(cc.cnt_hands) * 1.0) - sum(cc.cnt_walks) * 1.0) > .5)

That example is for a VPIP greater than 50% but the same principle can be applied to other columns.

[Flag_Hippo]

Can someone explain to me how I could see the population tendencies on the HUD?
I mean like I am able to see it for me in the hand replayer.

You cannot see statistics for the entire population in the HUD. That can only be done by going to 'My Reports -> New Report' and creating an 'All Players Report'. Remove the 'Player' stat from the report (double click on it under 'Report Stats') to see the data from all players combined and not broken down into rows for individual players. You can then add the stats you want to the report by double clicking the ones you want under 'Available Stats'. Additionally if you add the following filter: NOT(Player is Hero) you'll see the data from villains only without your own stats mixed in.

[Tinman9956]

Thanks for the code, but it's coming up as invalid. What am I missing. Thanks again.

[Flag_Hippo]

Apologies that code is for something else. In an 'All Players' report the equivalent code is this:

Code: Select all

player.id_player in (SELECT p.id_player from player p, cash_cache cc where p.id_player = cc.id_player group by p.id_player HAVING (( sum(cc.cnt_vpip) / (sum(cc.cnt_hands) - sum(cc.cnt_walks)) > 0.5)))

[ommaha]

That looks very interesting. How would it be possible to change that to VPIP > 50 and only hands count towards that VPIP when between 4 and 6 players are dealt in the hand?
So basically want to make sure that someone is not listed as VPIP 55 if he played 100 hands heads up with VPIP 85 and 100 hands 6handed with VPIP 25.
Any help very appreciated

[Flag_Hippo]

You can create a custom VPIP stat for 4-6 players and then query that stat in the expression filter.