a few questions regarding expression filter in reports

[ommaha]

Hi,

I wanted to do some database analysis and I was wondering if there is a chance to do the following.

1) is there a way to filter stats for recreationals and regulars separately? Let´s say recreational having vpip>40 and/or pfr>30 when playing 4,5 or 6-handed as a criteria. And wanting to know how often recreational cbets the flop in 4betpots as an example

2) is there an expression filter for naming flops directly? So, f.e. flop is Q87,J87,T95,J76,963? It takes quite a bit to put that together with the normal filters

3) how can I filter for specifically UTG opens and specifically BB calls?

I would very much appreciate any help. Thank you

[Flag_Hippo]

1) is there a way to filter stats for recreationals and regulars separately? Let´s say recreational having vpip>40 and/or pfr>30 when playing 4,5 or 6-handed as a criteria. And wanting to know how often recreational cbets the flop in 4betpots as an example

You can create a custom 'All Players Report' and add the statistics/filters you want to use. You can then use an expression filter on the report to filter by VPIP and/or PFR - for example:

Code: Select all

#VPIP# > 40 AND #PFR# > 30

2) is there an expression filter for naming flops directly? So, f.e. flop is Q87,J87,T95,J76,963? It takes quite a bit to put that together with the normal filters

This is what a Q87 flop query looks like if you were to use an expression filter:

Code: Select all

((cash_hand_summary.card_1 % 13) = 11 OR (cash_hand_summary.card_2 % 13) = 11 OR (cash_hand_summary.card_3 % 13) = 11) AND ((cash_hand_summary.card_1 % 13) = 7 OR (cash_hand_summary.card_2 % 13) = 7 OR (cash_hand_summary.card_3 % 13) = 7) AND ((cash_hand_summary.card_1 % 13) = 6 OR (cash_hand_summary.card_2 % 13) = 6 OR (cash_hand_summary.card_3 % 13) = 6)

This post has more information on how the modulo function works.

3) how can I filter for specifically UTG opens and specifically BB calls?

There isn't a simple filter you can use for the position of callers but you can do it with an expression filter. Assuming 6 players dealt in that would be this:

Code: Select all

cash_hand_summary.str_aggressors_p LIKE '83' and cash_hand_summary.str_actors_p LIKE '38'

This post has more information on how the actors and aggressors strings work if you want to filter for different situations.

[ommaha]

Thank you very much. That is great help!