aggregated report setup

[griffith_white]

I wish to see how much are fish raising UTG in 6max games. I went to reports select new report picked all players than in filters selected NOT hero, player position = 3 I removed player from filters to get cumulative stat and when I go to add new expression filter I wish to add #vpip# > 40 and that is making an error in all players report. Any way I can do it properly ?

[Flag_Hippo]

I wish to see how much are fish raising UTG in 6max games. I went to reports select new report picked all players than in filters selected NOT hero, player position = 3 I removed player from filters to get cumulative stat and when I go to add new expression filter I wish to add #vpip# > 40 and that is making an error in all players report. Any way I can do it properly ?

1. You cannot use a simple expression filter like #VPIP# > 40 if you have removed the player grouping. You can leave the player grouping and the population statistics will still be on the summary line.

2. Bear in mind if you filter for a specific positon then that's also going to filter the players VPIP for that position only so when using #VPIP# > 40 you will only see players with a VPIP greater than 40 from position 3. If you want to filter your report based on a players overall VPIP then you will need to use an expression filter with a subquery:

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)) > .4)))

This expression filter will work with or without the player grouping.

[griffith_white]

thank you very much for explanation but it is super complicated for me. I will have to return to hand2note. I wanted to do same thing with pokertracker because it is much more precise stats in my opinion but making any report slightly more complicated will be impossible for me