Custom reports

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Custom reports

Postby Pyr00 » Mon Sep 03, 2018 6:06 pm

Hey, i want to know how to create a custom reports to analyse my database in spins(3h and hu games).

I want to create a custom report to analyse all the players i played but filter by for example more than 300 hands and less than 300 hands. And by position, for example: More or less than 300hands in 3h BUvBTN,BBvBTN, HU BBvSB,etc.

Any help pls ? thanks
Pyr00
 
Posts: 34
Joined: Sun Mar 19, 2017 12:42 pm

Re: Custom reports

Postby Pyr00 » Mon Sep 03, 2018 6:35 pm

Cant edit

I tried this on the All players report


This filters to hands where someone was dealt in with less than 300 hands in the database:

tourney_hand_player_statistics.id_hand in (SELECT thps.id_hand from tourney_hand_player_statistics thps where thps.id_player in (SELECT tc.id_player from tourney_cache tc where true group by tc.id_player HAVING sum(tc.cnt_hands) > 300))


but dont work :s, the tracker said like loading.. all the time https://gyazo.com/e74eea43296a970b9ea0a8e6cbd0d7a9
Pyr00
 
Posts: 34
Joined: Sun Mar 19, 2017 12:42 pm

Re: Custom reports

Postby Flag_Hippo » Tue Sep 04, 2018 7:04 am

Filters like this can generate a lot of PostgreSQL processing so can take a while to complete if you have a large database so I'd recommend testing the filter in a smaller database to make sure it works as expected.
Flag_Hippo
Moderator
 
Posts: 14440
Joined: Tue Jan 31, 2012 7:50 am

Re: Custom reports

Postby Pyr00 » Tue Sep 04, 2018 9:57 am

I tested in a short database like 1k spins not sure about hands but i will try and then info you again
Pyr00
 
Posts: 34
Joined: Sun Mar 19, 2017 12:42 pm

Re: Custom reports

Postby Pyr00 » Tue Sep 04, 2018 6:33 pm

Dont work.. still loading after 1h and test with 500 spins and more than 100 hands, so .. any help ?
Pyr00
 
Posts: 34
Joined: Sun Mar 19, 2017 12:42 pm

Re: Custom reports

Postby Flag_Hippo » Wed Sep 05, 2018 5:05 am

Please restart PokerTracker 4 using the logging enabled link on your Start Menu, reproduce this problem and then send your log file to is in a Support Ticket so we can see what's going on here. You can access the 'Logs' folder with the log file by clicking 'File --> Show User Data Folder' in the main PokerTracker 4 window and the file we need is the text file called 'PokerTracker4' or 'PokerTracker4.log' that is in that folder.
Flag_Hippo
Moderator
 
Posts: 14440
Joined: Tue Jan 31, 2012 7:50 am

Re: Custom reports

Postby Pyr00 » Wed Sep 05, 2018 10:14 am

i just sent the log.
Pyr00
 
Posts: 34
Joined: Sun Mar 19, 2017 12:42 pm

Re: Custom reports

Postby Pyr00 » Mon Sep 10, 2018 7:18 pm

BUMP , support didnt answer me in 4 days.. any help pls ? i sent the log and they said this:

It is valid SQL however, you are literally querying every single row in the tourney_cache table then grouping them together which is a massive process then doing two select IN statements which is another long process for as many results that would likely get returned.
Pyr00
 
Posts: 34
Joined: Sun Mar 19, 2017 12:42 pm

Re: Custom reports

Postby WhiteRider » Tue Sep 11, 2018 3:06 am

Please bear with us - more complex tickets can take some time to investigate. We haven't forgotten about your ticket.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Custom reports

Postby V1se » Fri Sep 14, 2018 8:33 am

I have exactly the same problem! I'm trying to add a line in those New Expression Filters to filter specific stats but also get the " Loading ... " error. Its only 30 games and about 400 hands so this is a very small sample.
V1se
 
Posts: 3
Joined: Tue Oct 28, 2014 9:11 pm

Next

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 19 guests

cron
highfalutin