Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.
Is it possible to create a custom stat to use in reports that will allow me to display my hands in blocks? I'm working with small blocks of 500, then 2500, then 10,000, as a way to monitor my improvements in areas such as Blind Defense/Blind Attack, Stealing etc.
Some mechanism would be helpful. Right now I'm manually sorting, and having to right down where the blocks start and end. If a date range filter could be set up, it would be help.
You can filter for date ranges with the normal Filters window.
I assumed you wanted to see a report with your stats split into "blocks". I you want to do that you'll need to build a stat to group by some criteria. If that's what you want to do, let me know what sort of thing you want to see and how you want to split up the blocks (e.g. we could do every 7 days, or something).
OK, import the attached "YearWeek" stat and add it to a custom report in the Holdem Cash Player Statistics section to split the report by week (you'll need to extract it from the .zip, and I've included my YearMonthDay stat too, which will split reports in a similar way but by day). Add the stats you're interested in, save the report and run it.