Ok, here's the problem I have. I am trying to do population analysis by dividing the player pool according to a few stat filters. So for example, I want to see the collective stats of all people who VPIP more than 25 but less than 38, who 3bet more than 8% and for whom I have more than a 1000 hands against.
if I go and make an all players report with these parameters I can have it relatively fast in less than a minute. That is, I get a list of with each player who fits these criteria along with their individual stats and at the bottom, I get the collective stats of that group.
My problem is that I want to see their collective data based on stack depths. So I don't want to see any player's name, I just want their collective stats using according to stack depth filtered by the stats parameters I defined above. But if I remove the player stat and replace it with a custom stat I 've made about stack depth, the report craps out, it doesn't work.
I tried using the expression formula you posted above exactly as you posted it in order to see if it works. Alas, it doesn't.
- Code: Select all
player.id_player in (SELECT p.id_player from player p, tourney_cache tc where p.id_player = tc.id_player group by p.id_player HAVING (( sum(tc.cnt_vpip) / (sum(tc.cnt_hands) - sum(tc.cnt_walks)) < .31)))
Right now, I have had it running for 25 minutes and it doesn't return any results. I 've seen another player in a similar thread who tried this and had the same problem and you told him to file a ticket. I am not interested in doing that.
I do know there's an alternative way that makes the report actually work. Basically you take the players name that fit your criteria and you create a filtered list of their collective stats on the report you want, like so:
player.player_name = '
player1' OR player.player_name = '
player2'OR player.player_name = '
player3'
As you can imagine, while this works, it's very time consuming, if you want to insert each specific name into the player.player_name=" " code.
So I am thinking I can export the first player report, take the column with the list of usernames and then do this automatically. The automatic part eludes me however. Any ideas?
Thanks