How to analyze reg players by making aliases

[akimuhamaguchi]

Hi,guys

I am trying to make reports or statistics by making aliases of regular players(like hands > 500) in 6max game but PT4 can not combine players who play on the same table.
I've tried to filter the player pool reports but it did not work because in the situation bellow cnt_hand or Hands(statistic) does not mean hands played by each player, right??
Does anyone have an idea or know the forum where this problem already solved??

Regards

[Flag_Hippo]

If the 'Filter on Active Player' option is turned off such as in a custom all players report then you will see all hands in the database from every players perspective. So for example in a database with 1,000 personal 6max hands the report would show 6,000 total hands for all players in the database (if there are no other filters applied). If you do not want your own data mixed in when doing population analysis you can add a filter for (NOT) Player Is Hero.

[akimuhamaguchi]

If the 'Filter on Active Player' option is turned off such as in a custom all players report then you will see all hands in the database from every players perspective. So for example in a database with 1,000 personal 6max hands the report would show 6,000 total hands for all players in the database (if there are no other filters applied). If you do not want your own data mixed in when doing population analysis you can add a filter for (NOT) Player Is Hero.

Thanks for a quick reply.
I've understood that the report show the total hands for the all the database.
I already know how to filter hands threshold after showing each player's name.(1. cnt_hands > 700)

In this situation, cnt_hands means the total hands, so if I filter as 'cnt_hands > 300' doesn't make any sense,right??
I want cut the players who only plays more than personal 300 hands without showing each players name like this, so do you know how to do this without showing each other player name??(2)

[Flag_Hippo]

When using a simple expression filter like cnt_hands that will be just be applied on the values that are actually visible within the hands column in the report so that only works for each player when the 'Player' statistic is still included. If you've removed the 'Player' statistic from the report then that requires a more complex expression filter:

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 (( CASE WHEN (sum(cc.cnt_hands)) <> 0 THEN (sum(cc.cnt_hands)) ELSE 0 END > 300)))

[potamito]

It´s been a while...I would like to replay hands from a certain players pool...How can I achieve this?

Let´s assume I have a list of regulars on my games but, I would like to filter them out.

[Flag_Hippo]

What is the specific criteria you want to use for the filtering those hands? Are these heads up hands or multiway hands? Cash or tournament?

[mooooNy]

@OP this might be of interest for you: https://forumserver.twoplustwo.com/185/heads-up-sng-spin-gos/help-using-pt4-analyse-population-tendencies-1208561/