Stats comparison for tournaments

[BoiledFrog]

I want to compare stats on tournaments. I just want to look at simple things like VPIP and PFR and compare this against the number of hands played. More hands played should indicate a better tournament. Can you do this inside PT3? Or do I have to write a custom query in Postgres?

[kraada]

There are three ways I could see to do this in PT3:

(1) Sort the Tournaments tab by Hours - this gets you a list of tournaments ordered by length. Double click one (or several) of them to filter to the clicked tournament(s) - then go to the General tab. You can see your VPIP in the filtered tournament(s) there. Filter to a different set of tournaments and compare.

(2) Create a custom report using a custom SQL query to filter down to tournaments with certain ranges of hands. This is going to be more complicated, obviously.

(3) Create a custom column in the Holdem Tournament Player Statistics section which contains just the value: holdem_hand_player_statistics.id_tournament and has the group by box ticked. Use that in a custom stat. Add this to a custom report in the Player Statistics section and you'll see TPS section stats grouped by tournament - then you can add the Hands stat and VPIP and PFR and sort by clicking column headers.

I think (3) is probably the best approach for what it sounds like you might want to do - but I listed (1) and (2) in case either of those appealed to you more.

[BoiledFrog]

I created a new column, tourney_id, using "Configure Stats". It's configured to be "tourney_holdem_hand_player_statistics.id_tourney". I can see it at the bottom of the "Configure Statistics" dialog but I can't see it in the "Holdem Tournament Player Statistics" report under "All Stats".

What am I missing?

[kraada]

Once you have the column created you need to build a stat using it. Create a stat in that section whose value expression is just that value - it's going to display the id number for the tourney that it's using to group by - so create an appropriate title and width. Then once you've got the stat built, that's what you'll see (and use) in your report.

[BoiledFrog]

OK, that seems to work. However the stat doesn't display in the report. I also added a stat, tourney_no, to use the site-specific tournament ID as well. Neither display. I want to be able to drill down into the individual tournaments and it's difficult without some sort of tournament identifier.

[WhiteRider]

Did you fill in the Format tab of your new stats? If there is no Title and Width the report doesn't know how to display the stats.

Tutorial: Custom Reports and Statistics

[BoiledFrog]

Yeah, that was the problem. Thanks.

Incidentally, what units is the width in? Apparently it's not characters. I had to use a width of 70 for a 10 character field. Is it pixels?

[WhiteRider]

I believe it is pixels, yes, although it could be related "points" that font sizes are defined in.