Preflop Aggressor Position

[overboard45]

I would like to pull the stat for the preflop aggressor position in a Hand Report. The column I'm looking for is val_p_raise_aggressor_pos which is found the PokerTracker Database Schema documentation. When I create a column and a stat, the hand report has the following error:

"Unable to execute query: Fatal Error; Reason ERROR: column "cash_hand_summary.id_hand" must appear in the GROUP BY clause or be used in an aggregate function LINE 1:SELECT(cash_hand_summary.id_hand) as "id_hand",..."

The rest of the message is cutoff, and this error does not appear unless the new stat is present on the report.

Hand Column Name: p_raise_aggressor_pos
Hand Column Expression: cash_hand_player_statistics.val_p_raise_aggressor_pos


Stat: PF Aggressor
p_raise_aggressor_pos

[Flag_Hippo]

That's working for me. Is the 'Group By' option in the column enabled or not? If it's enabled please turn it off and refresh the report.

[overboard45]

Thank you @Flag_Hippo. Removing the "Group By' option in the column tab allows the stat to work. Nice job

[overboard45]

I have another question regarding the preflop aggressor. I would also like to get the player name of the aggressor in the hand report.

I wasn't able to get anything to work or find other examples on the forum.

Could you show how to code a cash hand column for this?

[Flag_Hippo]

Unfortunately I don't know or have any SQL for that.