Hole card strength statistic?

[Ganadai]

Is there any statistic that ranks hole cards by their strength, or is it possible to change the interger values returned by the id_holecard table? I'd like to be able to sort my starting hands by their relative strength, but can't seem to figure out a way besides just sorting them by Win %.

[WhiteRider]

No there isn't, but you could build a custom stat based on a combination of the two id_holecard values.
Tutorial - Custom Reports and Statistics

[Ganadai]

Thank you for the response WhiteRider. I figured out that in the postgres database I can add a columns to the lookup tables, so I added one to lookup_hole_cards and named it id_handrank169. I then made a custom stat in PT3 called PF Rank with the value expression id_handrank169.

Now, when I add the stat to the 'Position Hands' report it displays exactly what I want it to. However, if I try and add the stat to the 'Position Statistics' report it breaks the positions up into rows based on the handrank169 value. I'd like it to just show the max id_handrank169 value for that position. I tried different id_handrank169 combinations such as unchecking "Group By" and changing "Summary Type" to MAX, but nothing seems to work. Any ideas? Thanks.

[kraada]

Isn't that just going to trend towards the max for all positions then? I mean, eventually you'll be dealt AA everywhere.

[Ganadai]

The handrank169 column looks something like:
1 AA
2 KK
3 QQ
.
.
.
168 82o
169 72o

So what I'm looking for it to show is the max rank (worst strength) of the hole cards a player was dealt in each position. Without any filters, this will eventually show 169 for every position, but if I add a filter to only show hands a player saw the flop with, then it will display the highest rank (worst strength) hole cards a player decided to try and play from each position. If I add a filter to only show hands a player raised preflop it will show the highest rank (worst strength) hole cards a player raised preflop with.

[kraada]

Ah, I see what you mean.

Create a column, call it val_max_id_holecard169 or some such.

Use the definition:
max(id_handrank169)

for the column. Then use the column in your stat and it should work.

[Ganadai]

Thank you, that works perfectly.