Player Pool Report

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Player Pool Report

Postby Mr.Balzter » Sun Sep 08, 2019 9:11 am

When I'm trying to run an "All Players Report" to look at population tendencies of winning players it is my understanding that I can remove the "Player" stat and it will put all the players from that report onto one line.
However I receive this error.
Unable to execute query: Fatal Error: Error: (ERROR: aggregate functions are not allowed in WHERE LINE 1: ...OM cash_hand_player_statistics WHERE (((sum((case...
Mr.Balzter
 
Posts: 2
Joined: Fri Dec 21, 2018 7:51 am

Re: Player Pool Report

Postby Flag_Hippo » Mon Sep 09, 2019 6:00 am

Are you getting that error after just removing the 'Player' stat from a default 'All Players' report (no filters, no custom filters, no custom stats) leaving only the 'My C Won' and 'Hands' stat?
Flag_Hippo
Moderator
 
Posts: 17133
Joined: Tue Jan 31, 2012 7:50 am

Re: Player Pool Report

Postby Shmuuzer » Wed Nov 11, 2020 11:38 am

Flag_Hippo wrote:Are you getting that error after just removing the 'Player' stat from a default 'All Players' report (no filters, no custom filters, no custom stats) leaving only the 'My C Won' and 'Hands' stat?


I have a similar issue where I'm not able to see the "My C Won" and "Hands" but the actual hand reports aren't showing. I removed the "Player" stat and chose the quick filter "NOT(Player is Hero)" but the image attached is what I'm getting. What must I do?
Shmuuzer
 
Posts: 10
Joined: Sun Jul 12, 2020 4:36 pm

Re: Player Pool Report

Postby Flag_Hippo » Wed Nov 11, 2020 1:14 pm

I don't see any image attached to your post.
Flag_Hippo
Moderator
 
Posts: 17133
Joined: Tue Jan 31, 2012 7:50 am

Re: Player Pool Report

Postby Shmuuzer » Wed Nov 11, 2020 11:50 pm

Flag_Hippo wrote:I don't see any image attached to your post.


My apologies, here is the image I'm getting. Not sure what steps to take after seeing this
Attachments
pt4.PNG
(12.83 KiB) Downloaded 3708 times
Shmuuzer
 
Posts: 10
Joined: Sun Jul 12, 2020 4:36 pm

Re: Player Pool Report

Postby Flag_Hippo » Thu Nov 12, 2020 6:40 am

Shmuuzer wrote:I have a similar issue where I'm not able to see the "My C Won" and "Hands"

This isn't the same issue as the OP and you mentioned that you cannot see "My C Won" and "Hands" but they are there in your screenshot.
Shmuuzer wrote:but the actual hand reports aren't showing.

You will not see individual hands in a player report - you will need to create a 'Hand Report' instead to see those. If you want to filter from every players point of view in a hand report you will need to click the 'Filters' link, select 'Add New Expression Filters' and turn off the 'Filter on Active Player' option.
Shmuuzer wrote:but the image attached is what I'm getting. What must I do?

If you want to review population data then add the statistics you want to see to the report by searching and double-clicking on them under 'Available Stats':

Guide: Creating My Reports
Flag_Hippo
Moderator
 
Posts: 17133
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 0 guests