3bet vs positional raise

[Skull_AK]

hello everybody
i would like to know if exists a built stat which tell me the 3bet to a specific position
i mean if i raise from EP and a villain makes a 3bet i need the stat of 3bet to EP
thanks in advance and sorry for my poor english

[kraada]

It's not currently possible to build this statistic at this time due to the way data is stored in the database. We are looking into ways to fix this issue for future releases but I do not have a definite time frame on this issue at this point.

[Skull_AK]

thanks for the answer
i'll be waiting for the stat in future releases
ty.

[bender]

Is there a way I can get notified when this becomes possible?

[WhiteRider]

If you create a Support ticket with the request we can link it to our system so that you get a notification when the fix is released.

[majonyjony]

this is not correct? (OR UTG)

sum(if[ holdem_hand_player_detail.val_p_raise_aggressor_pos = 7 AND holdem_hand_player_statistics.flg_p_3bet = 'TRUE', 1, 0 ] )

[kraada]

That will count the hands for player X where the last person who was not player X and who raised was in position 7, and player X made a flop 3-bet.

Some hands that would also come up here include UTG limping, UTG+2 raising, player X 3-betting on the button and UTG limp-reraising all-in. This is why you need to be very careful with this particular sort of stat - it's very easy to get situations you do not want to count.

[majonyjony]

TY Kraada!

works best with
substring(lookup_actions_p.action from 1 for 1)='RR' ???

sum(if[ substring(lookup_actions_p.action from 1 for 1)='RR' AND holdem_hand_player_detail.val_p_raise_aggressor_pos = 0 AND holdem_hand_player_statistics.flg_p_3bet= 'TRUE', 1, 0 ] )

Not sure RR

[WhiteRider]

works best with
substring(lookup_actions_p.action from 1 for 1)='RR' ???

That won't do what you want. substring xxx from 1 for 1 means from character 1, for 1 character, so will return the first character of the actions string. If you want to check more than one character (here you're comparing 2) you would need to use "from 1 for 2".
However, it is easier to use:
lookup_actions_p.action LIKE 'RR%'
Search for "pattern matching" in this tutorial.

I'm not sure what you're trying to do with that expression, though - it doesn't seem anything like the previous discussion.
Here you're counting the number of hands where a player's first two actions preflop were raises, including a 3-bet, when the last other player to raise was the button (pos 0).