Villain statistics depending on position

[slickric]

I want to get the following statistics for villain based on his Position (IP / OOP):

Cbet Flop IP | OOP
Cbet Turn IP | OOP
Cbet River IP | OOP

Fold to Cbet Flop IP | OOP
Fold to Cbet Turn IP | OOP
Fold to Cbet River IP | OOP

and then specific for how much did he fold after he did not Cbet:

Fold after NoCbet Flop IP | OOP
Fold after NoCbet Turn IP | OOP
Fold after NoCbet River IP | OOP

I tried to figure out but couldn't get it done

[WhiteRider]

If these are for use in the Hud then you do not need specific stats for in and out of position. There is a property which you can set to separate in/out of position.
Select the stat(s) and set the 'Has Position' property to in or out of position. This is available for the vast majority of postflop stats.

If you need them for reports then let us know and we can give you some more information about that, but take a look at how the stat "Call F CBet In Pos" is made as an example. One of the columns it uses is "cnt_f_cbet_def_action_raise_in_pos" and that shows a way of determining in/out of position with regards to facing CBets.

[slickric]

i would need them as report

[WhiteRider]

I took another look at these and there is actually a pretty straightforward way to make stats like these.
You can use:

cash_hand_player_statistics.flg_f_has_position

..to determine if the player was in position or not.
For example, you can count out of position flop CBets like this:

sum(if[cash_hand_player_statistics.flg_f_cbet and not(cash_hand_player_statistics.flg_f_has_position), 1, 0])

There are turn and river versions of that database field too.