I have same issues.

Actually there are stats like: 'My Currency Jackpot Taken' and 'Game Currency Jackpot Taken'. But these Stats show (in my opinion) "random" numbers and not the additional jackpot rake taken.

you lost 140pound, when folded Preflop from BB/SB i guess.
So you didnt VPIP and everytime you are in BB you loose 1bb etc.

I think I found a way, after reviewing some pt4 warehouse stats. this is COvsBU(~9bb) 3bet. sum(if[char_length(cash_hand_summary.str_aggressors_p) >= 4 and cash_hand_player_statistics.flg_steal_att and cash_hand_player_statistics.flg_p_4bet and cash_hand_player_statistics.position = 1 and (substring...

What am I doing wrong? I want to show probability what the BU 4-bets against a ~9bb 3bet from Blinds. sum(if[cash_hand_player_statistics.flg_p_first_raise AND cash_hand_player_statistics.flg_p_4bet AND cash_hand_player_statistics.position = 0 AND ((cash_hand_player_statistics.position = 8 and cash_h...

rebuild your custom cache of your database.

Database --> Database Managment --> Rebuild Cache --> Custom Cache Rebuild

If your Database is very big it can take very long!

Thank you very much! It works now. after you gave me the food for thought, i did it like this tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps, player p, tourney_blinds tb where thps.id_player = p.id_player and thps.id_blinds = tb.id_blinds and ...

First of all thanks and its working now. How can I also specify that the 3Bettor NOT raised All-in . I tried something like this, but its not working... and other several stuff :roll: (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 25 and 10000 AND tourney_hand...

First of all thank you very much! While the whole expression is working perfect when testing it in My Reports, it is not possible for me to create a Column with this expression. As it seems this code, tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics ...

Not sure if its the right topic. I am trying to create this stat: Fold to PF 3Bet After RFI (20bb+) sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 20 and 10000 AND tourney_hand_player_statistics.enum_p_3bet_action='F' AND tourney_hand_player_statistics....

tried to implement this. tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps where thps.flg_p_first_raise and thps.amt_before / thps.amt_blind >= 7 3Bet Preflop AI: sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_b...