I'd like to build a stat that counts how many times I've lost vs a running full house... how I can define that situation?

have you tried to uncheck 'show in report when only available'?
Have you clicked on ok or apply before check whether is available or not?

Ty for the reply... is there no workaround?

Try reboot your computer

The column is invalid but the SQL code is ok, PT4's parser do something wrong, I guess it the CASE PostgresConnection (Error)] Error: Unable to execute query: Fatal Error; Reason: Error: (ERROR: syntax error at or near "(" LINE 8: ... AND ((cash_hand_player_statistics.position)((CASE whe.....

How can I filter hands where on the BB there's a 20/15 player? I guess I should use a subquery but maybe there's another, quicker, method

I'm looking for a DB level solution, I don't want to be obsessed with AI adjusted anymore, so I come up with a few solution, like using a trigger to autodelete the column after update. Maybe I can delete the column from the DB but I don't know how PT4 is going to handle a missing column. Any help he...

I'm trying to build a stat that shows me the times I flopped trips and villain flopped a full house... but my statement is invalid sum(if[((((cash_hand_player_combinations.flg_f_threeoak AND cash_hand_player_combinations.val_f_hole_cards_used = 1 AND cash_hand_player_combinations.id_f_hand_strength ...

Coding the flopped set and lost is easy, but how can I code the spot below? PokerStars - €0.25 NL (6 max) - Holdem - 4 players Hand converted by PokerTracker 4 BB: 198.48 BB (VPIP: 31.96, PFR: 25.82, 3Bet Preflop: 10.22, Hands: 602) Hero (CO): 119.32 BB BTN: 59.04 BB (VPIP: 35.23, PFR: 14.44, 3Bet P...

How can I count the times when I see the showdown and villain shows up with AA?