Creating a Custom ReportCreating a custom report is simple - the
Custom Reports guide explains all the elements of custom reports so I'll just explain the steps you need to take to create your own report, and then in the
next post I'll create an example report with detailed steps and images to walk you through it.
Select the
Cash Games > Reports tab.
The first thing to do is decide which
section the report will be in and select it from the
Section dropdown list.
You should then see the
Available Stats list populate with stats from the selected section.
Now you need to give your report a name (by typing in the
Name field) to allow you to identify it in future - you cannot run a report until you have named it.
To add statistics to your report double click them in the list of
Available Stats and they will appear in the
Report Stats list above.
You can filter the available stats by selecting a
Category to make it easier to find the stats you want.
When you have added your stats you can change they order they will be shown in the report by selecting a stat in the
Report Stats list and using the
up and down arrows to move them.
That's all you really need to do, but there are further options to allow you to tweak your report contents, sorting order, etc., should you want to.
FiltersThe blue
Filters link allows you to filter your report in three ways.
These three methods can be combined, so for instance you can apply both simple and custom filters together. Any report filters that you apply will override any filters already active (or applied) via the main Filters button, though.
1. The most basic is the
Filter on Active Player option.
This determines whether the report will show information for just the player currently selected in the Player List or for all players.
Be aware that if you uncheck this option then your report will show information for all players - this can lead to very large reports which can take a very long time to genarate. In particular you need to be really careful with reports in the Holdem Cash Hands section - showing every hand in the database from every player's point of view will mean a very big report!
However, if you want a Holdem Cash Player Statistics report (for instance) to show stats for more than one player you must uncheck this option.
2. The
Simple Filters button is exactly the same as the main
Filters window but filters applied here will only apply to, and will be saved with, this report.
If you have any Simple Filters applied the button text will go blue.
Note: Filtering rules apply here as described in "Sections" - if you filter for specific actions or types of hands it will only affect reports in the Holdem Cash Hands and Holdem Cash Player Statistics sections - Holdem Cash Session and Holdem Cash Sessions reports will NOT be filtered to show results from only a few hands; these will always show results from whole sessions.
3. You can also enter your own
Custom Filters for situations not covered by the Simple Filters window using statistics or columns in the same section as the report.
To do this enter a Filter Expression.
The easiest way to do this is to use the Insert link to select your chosen column, statistic or operator but once you are used to the format you can just type in the expression.
This allows some quite advanced filters, but it doesn't need to be complicated.
For example, to filter a Holdem Cash Player Statistics report to only show players who have played more than 100 hands you could enter this expression:
#Hands# > 100
Statistic names are identified using # either side. To enter this same filter using the Column instead of the Statistic you would enter:
cnt_hands > 100
The above expressions for the number of hands are equivalent whether you use the statistic or column, but let's say you want to filter to only show players who have 3-bet on the river a certain number of times. The "3Bet River" stat is a percentage of times they bet when they had the opportunity (not a count of how many times they 3-bet) so we need to use the column "cnt_r_3bet" in the filter expression:
cnt_r_3bet > 10.
Note: This will only filter the report to show those players who 3-bet on the river more than 10 times - it will NOT filter their stats to only those hands where they 3-bet, it will still show their overall stats.
To see only stats from the hands where they 3-bet the river you need to use the Simple Filters button.
SortingThe
Sorting window allows you to define the order in which your report will be sorted.
You can sort by more than one stat and the sorting will be applied in the order defined on the right.
For instance if you want to sort a Holdem Cash Hands report by limit then by amount won so that you see all hands from the same limit together but sorted by amount won within each limit you would double click Limit and Amount Won on the left and then make sure that Limit was listed first on the right hand side (using the up/down arrows).
Double click a stat on the right hand side to change the sort order between ascending and descending.
AdvancedThe
Advanced link allows you to specify whether or not the report has a summary (totals) line at the bottom, and to define colours for rows within the report based on the value of a statistic or column in the same way you define filter expressions.
See the window for an example expression.
To see what RGB values to use for different colours open the Windows colour-chooser window and note the RGB values for your chosen colour - for instance you can access this by double clicking one of the colour blocks in the
Settings Window.
Running ReportsWhen you are happy with your report click the
Save button.
You can then run your report by clicking the
Run Report button and the results will be shown in the main part of the report window.
This can take a while to populate if there is a lot of information to be retrieved for your report.
Tip! If you click Run Report before saving PT3 will ask you if you want to save - you must save in order for your changes to be used when you run the report.
Managing ReportsNow that you have saved your report it will be available for use any time you visit the Reports tab.
To access it again select the appropriate section then choose your report name from the
Report dropdown list.
You can also click the
Export button to save your report as a file outside PT3 for backup or to copy to another computer or share with other PT3 users via the
Repository.
If you download a report from the Repository, or want to import one of your own reports that you removed from PT3, use the
Import button.
If you have a report that you no longer want to keep in PT3 click the
Remove button to delete it.
If you previously exported this report then the file you exported it to will not be affected so you can re-import it later.
If you want to start over with a new empty report click the
New button - if you hadn't saved the current report you will be asked whether you want to save it. As long as you have saved it you can get back to your previous report at any time by selecting it from the dropdown list but you can only have one report open at once.