Creating a verticle column label for custom report

[DOMIATED89]

Hello,

I can see looking at the positional stat for full-ring the following two codes:

Expression = val_position_abs

Code: Select all

lookup_positions.absolute_position

Format type = str_position

Code: Select all

lookup_positions.description

How can I emulate this "look up" feature, so I can provide a verticle labeled list of situations (eg: limp pot, 2b pot, 3b pot, 4b pot)? I would so this so I can have the horizontal free for normal stats (bb/won, hands played etc).

It would neaten up my custom reports if I didn't need to add everything horizontally. Ideally it will be a table format with 1 line per pot type. Simillar to how the position feature works.

Assuming I can create verticle labels, how do I then assign a the name of the label?

[DOMIATED89]

Another example would be if I wanted to label each street vertically and use the horizontal for stat comparisson. How can I create a verticle column labeled: Flop, Turn, River?

[Flag_Hippo]

There isn't the equivalent of lookup_positions for the type of pot but it's still possible with a custom statistic. To have a line for each type of pot you would need to do the grouping within the custom statistic - this thread has an example - it's for the type of made hand on the flop but the principle is the same. To test for whether a pot is limped e.t.c. you can use the aggressors string:

Code: Select all

char_length(cash_hand_summary.str_aggressors_p) = 1

This is the code for a limped pot, 2 would be for a 2bet pot and so on. See this post for more information on the aggressor and actor strings.

[DOMIATED89]

I already have coded for limped, 2bet pots etc for stats like bb/100, hands played etc. However, each stat has its own column across the horizontal axis in the report.

How can I convert my stats to create a vertical column with text labels "Limped pot" "2bet pot" "3bet pot" etc.

[Flag_Hippo]

How can I convert my stats to create a vertical column with text labels "Limped pot" "2bet pot" "3bet pot" etc.

I covered this in my previous reply. Pease take a look this thread for an example - it's for the type of made hand on the flop but the principle is the same.