I am currently setting up my database to analyze Hero in the Big Blind (BB) vs Small Blind (SB) scenarios, and I want to make sure my logic is 100% correct and that I'm not missing or misfiltering any hands.
I used a combination of a Graphical Quick Filter and Custom Reports with Expression Filters.
Could someone please review my setup and confirm if this is the correct way to isolate these three specific spots?
For a clean Raise First In (RFI) from the Small Blind, I created a graphical Quick Filter. Here's the screenshot:
For SB First VPIP: I created a report with the following filter:
tourney_hand_summary.str_actors_p LIKE '9%'
For SB limp: I I created a report with the following filter:
tourney_hand_summary.str_actors_p LIKE '9%' AND tourney_hand_summary.str_aggressors_p NOT LIKE '89%'
