Report by preflop action

[mattgoody]

Is there a way to create a report that filters results/stats by preflop action, such as the one thats in HM? For example, It shows my stats when theres a preflop raise in front of me, when the pots unopened b4 me etc... I might be retarded, but i couldnt make anything even remotely similar when i tried to make a report like this in PT3. Thanks.

[APerfect10]

Yes, this is definitely possible via a custom report. You would need to create a custom statistic that would display the action that you are facing pre-flop then you should be able to group on this to list all of your stats for each unique pre-flop scenario. A little complicated but very possible.

If I can find some time today I will play around with it and see what I can come up with.

Best regards,

Derek

[mattgoody]

I made a stat as an easier test that is just whether or not the player was the first to raise preflop. When i try to run the report there is an error because the query it tries to run does not omit the "WHERE" clause even tho there are no filters. IDK if this is better off in the bugs section, but i had already made a thread here so ill post it. Below is from the log file, The top one is without a players field included, which shows the WHERE clause where it should just be omitted. the bottom one worked, but it did not show the first_raise column, i just saw two rows for each player (as it should be). So it was just a table with a players column and an amt won column. When i run it in pgadmin i get all 4 columns, but obviously you have chosen to hide some, since the count(hands) column is in the select but not displayed. I hope this was clear. Keep up the great work!

2008/04/10 13:30:53.072: [- Main -][Query] Executing SQL: SELECT ((case when(holdem_hand_player_statistics.flg_p_first_raise='t') then 'Raised first' else 'Did not raise first' end)), (sum(holdem_hand_player_statistics.amt_won)), (count(holdem_hand_player_statistics.id_hand)) FROM holdem_hand_player_statistics WHERE GROUP BY ((case when(holdem_hand_player_statistics.flg_p_first_raise='t') then 'Raised first' else 'Did not raise first' end)) HAVING ((count(holdem_hand_player_statistics.id_hand)) > 1)
2008/04/10 13:30:53.478: [- Main -][PostgresConnection (Error)] Unable to execute query: SELECT ((case when(holdem_hand_player_statistics.flg_p_first_raise='t') then 'Raised first' else 'Did not raise first' end)), (sum(holdem_hand_player_statistics.amt_won)), (count(holdem_hand_player_statistics.id_hand)) FROM holdem_hand_player_statistics WHERE GROUP BY ((case when(holdem_hand_player_statistics.flg_p_first_raise='t') then 'Raised first' else 'Did not raise first' end)) HAVING ((count(holdem_hand_player_statistics.id_hand)) > 1) ; Reason: Fatal Error (ERROR: syntax error at or near "GROUP" LINE 1: ...d)) FROM holdem_hand_player_statistics WHERE GROUP BY (... ^ )
2008/04/10 13:33:52.031: [- Main -][Query] Executing SQL: SELECT (player.player_name), ((case when(holdem_hand_player_statistics.flg_p_first_raise='t') then 'Raised first' else 'Did not raise first' end)), (sum(holdem_hand_player_statistics.amt_won)), (count(holdem_hand_player_statistics.id_hand)) FROM player, holdem_hand_player_statistics WHERE (player.id_player = holdem_hand_player_statistics.id_player) GROUP BY (player.player_name), ((case when(holdem_hand_player_statistics.flg_p_first_raise='t') then 'Raised first' else 'Did not raise first' end)) HAVING ((count(holdem_hand_player_statistics.id_hand)) > 1)
2008/04/10 13:34:17.034: [- Main -][Query] Query execution time: 24781.55343666 ms : SELECT (player.player_name), ((case when(holdem_hand_player_statistics.flg_p_first_raise='t') then 'Raised first' else 'Did not raise first' end)), (sum(holdem_hand_player_statistics.amt_won)), (count(holdem_hand_player_statistics.id_hand)) FROM player, holdem_hand_player_statistics WHERE (player.id_player = holdem_hand_player_statistics.id_player) GROUP BY (player.player_name), ((case when(holdem_hand_player_statistics.flg_p_first_raise='t') then 'Raised first' else 'Did not raise first' end)) HAVING ((count(holdem_hand_player_statistics.id_hand)) > 1)
2008/04/10 13:34:19.675: [00002092][QueryReportCtrl] Query load time: 2593 ms

-Matt

[mattgoody]

Also, how do i do "else if" statements in the custom columns and stats? I can embed another if into the then clause of the first, but this only works once (i.e. i cant embed a third if statement into the 2nd ones then part)(i could have done something rong tho, but i still feel like there must be another, more optimal way that i just am not realizing), plus since you convert it into the case syntax for pgsql anyway, theres got to be a better way for "else if's"

[APerfect10]

Please export this report then send it to me via the Support system so that I can look a little more closely at it.

There are some limitations such as the two embedded if statements. We will be expanding upon this eventually...

Best regards,

Derek