help on customized report

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

help on customized report

Postby silbema » Mon Jul 20, 2009 8:32 am

Dear all
can anybody help me???

I would like to make a customized report.

To analize my biggest mistake while playing I would like to get a list with the two biggest losses per tournament relative to the chipcount at that moment. I made about 3.000 Tournatment, so I would have 6.000 Hands to analyse.

Can anybody show me what I have to do?

many thanks for your help.

Martin
silbema
 
Posts: 7
Joined: Sat Jun 21, 2008 3:39 pm

Re: help on customized report

Postby WhiteRider » Mon Jul 20, 2009 8:51 am

I don't think you can do exactly what you want - you won't be able to create a report of exactly the 2 biggest pots per tournament.

The simplest way to do this will be to sort by the "BB Won" column in the Texas Holdem > Tournaments > Tournaments > Tournament Hands report.
This will bring the biggest wins and losses (in terms of BB) in each tournament to the top/bottom of the list so that you can quickly see them.
You can then also replay them by clicking the 'Play' icon to the right of the report.

Alternatively you could add a filter for certain pot sizes using the built in Filters so that only the hands with bigger pots (in BB) are shown.

You could create a custom report in the Holdem Tournament Hands section and filter to show exactly what size pots you like (in BB) or sort by size, but this would show all hands, not just one or two from each tournament.
Custom Reports guide
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: help on customized report

Postby silbema » Mon Jul 20, 2009 9:13 am

Thanks for the quick answer,

I would like to make an automatic run if there is a special texture of the flop etc... which makes me loose.
So your proposal for solution is not helpfull.

Years ago I learnt to make "select" queries with databases at school. Do I have a possibility to work with such queries also with PokerTracker?
silbema
 
Posts: 7
Joined: Sat Jun 21, 2008 3:39 pm

Re: help on customized report

Postby WhiteRider » Mon Jul 20, 2009 10:08 am

There are filters for board "texture" too, on the Filters > Texture tab.
If you don't want to filter for texture but instead want to display the strength of your hand on the flop in a report then you can add the "Made Hand Flop" stat to your report, or there are some user-built flop-strength custom reports available in the Repository. You could add a filter for large pots to these reports too.

If this still isn't what you want to do, please explain in more detail.

You can write queries directly to the database yourself too if you wish.
The database structure is documented in the Database Schema.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 26 guests

cron
highfalutin