Help! Trying to make modified Global Game Statistics Graphs

[kceow2981]

So here is what I'm trying to do. I want to make a series of graphs that are similar to the Global Game Statistics Graph for "Winning Hands at Showdown." What I'm trying to do is make a bar graph/histogram for each Pot Size (<20BB, between 20 and 40BB, between 40 and 60BB etc.) where the x axis is simply a bar for each made hand (High Card, Pair, 2 Pair... Full House etc.) and the Y axis is the % of how often each hand is seen as the winning hand at showdown.

Now, I don't think you can make custom graphs in PT4, and I couldn't configure/filter the stock one the way I like... So I wanted to try to make a custom hand report where I filter on Pot Size, the fact that the hand went to showdown, the board texture, AND I wanted to filter on the player statistics of the players that made it to showdown. Specifically I wanted to see the results of "Fishy" players, those with VPIPs of like 35 and higher and a PFR of like 7 or lower, to see how often they show up with crumby hands vs. premium hands at showdown. Once I had this large collection of hands, I'd export the report as a .csv file and import it into Excel and then make my desired bar graphs from the data. I'm pretty sure it would work.

However here is my problem.. I don't think you can filter on things like a players VPIP and PFR in a hand report right? So what can I do? Is there some sort of work around? Is there a simpler/different way to get the result I want? Please let me know

[Flag_Hippo]

That would require an expression filter with a subquery like this:

Code: Select all

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps where chps.flg_showdown and chps.id_player in (SELECT cc.id_player from cash_cache cc where true group by cc.id_player HAVING ((sum(cc.cnt_vpip) * 1.0) / (sum(cc.cnt_hands) * 1.0) - sum(cc.cnt_walks) * 1.0) > .35))

This will return hands where a player with a VPIP greater than 35% reached showdown and for more on how SELECT works see here. Bear in mind that the hole cards in the report will still be from heros perspective unless you turn off the filter on active player option in which case you will see the hands from the perspective of every player dealt in. You can add further simple filters but that will increase load times since these are complex queries but you could experiment with filters in a smaller database to make sure it works as you expect.

[kceow2981]

Just to verify, in my hand report in PT4, I would click "Filters" on the left and paste what you wrote into "Edit Existing Expression Filters" correct? Do I need to put in the first "SELECT ALL"? or is that implied by putting text into this box? I am wondering because PT4 is halted during this query. It's just loading and not producing any results. I set it to only find the 5 most recent hands that meet this criteria, is this query THAT laborious/processing intensive? Or is there something wrong.

Also if I wanted to add in the constraint that the players had a PFR below 8% would the following be the correct expression? Thanks for the help

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps where chps.flg_showdown and chps.id_player in (SELECT cc.id_player from cash_cache cc where true group by cc.id_player HAVING ((sum(cc.cnt_vpip) * 1.0) / (sum(cc.cnt_hands) * 1.0) - sum(cc.cnt_walks) * 1.0) > .35 AND (sum(cc.cnt_pfr) * 1.0) / (sum(cc.cnt_pfr_opp) * 1.0) < .08))

[kceow2981]

This is the error message I get when I try to use this expression in the filters section of the hand report.

[Flag_Hippo]

Just to verify, in my hand report in PT4, I would click "Filters" on the left and paste what you wrote into "Edit Existing Expression Filters" correct? Do I need to put in the first "SELECT ALL"? or is that implied by putting text into this box? I am wondering because PT4 is halted during this query. It's just loading and not producing any results. I set it to only find the 5 most recent hands that meet this criteria, is this query THAT laborious/processing intensive? Or is there something wrong.

Just paste the code in. I also misspoke above and simple filters can mess with the parser with these types of queries so everything needs to be in the expression filter.

Also if I wanted to add in the constraint that the players had a PFR below 8% would the following be the correct expression?

Yes.

This is the error message I get when I try to use this expression in the filters section of the hand report.

There is a known issue with some of these filters but you may see hands if you select 'All Hands' instead of 'Most Recent 100 Hands'.