Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by 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
by 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
by 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
by 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
by 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
by 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
by Pyr00 » Wed Sep 05, 2018 10:14 am
i just sent the log.
-
Pyr00
-
- Posts: 34
- Joined: Sun Mar 19, 2017 12:42 pm
by 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
by 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
by 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
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 19 guests