Page 1 of 1

Creating a verticle column label for custom report

PostPosted: Thu Jul 11, 2024 11:00 am
by 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?

Re: Creating a verticle column label for custom report

PostPosted: Thu Jul 11, 2024 11:37 am
by 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?

Re: Creating a verticle column label for custom report

PostPosted: Thu Jul 11, 2024 12:49 pm
by 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.

Re: Creating a verticle column label for custom report

PostPosted: Thu Jul 11, 2024 1:07 pm
by 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.

Re: Creating a verticle column label for custom report

PostPosted: Thu Jul 11, 2024 1:12 pm
by Flag_Hippo
DOMIATED89 wrote: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.