Aggregate Player Report

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Aggregate Player Report

Postby o0Q0o » Thu Nov 04, 2021 12:34 am

Would like to create a report where I filter for two players. Each line of the report represents position. For each position I would like to know the VPIP for all two players.

I successfully limited the report to the two players using the blue filter option.

I successfully removed Player from the report and added VPIP and Position.

Was hoping the result would be six lines, one for each position. Instead my report shows twelve lines ~ two players times six positions.

How do I create a report showing the VPIP for all two players for each position using a single line per position?
o0Q0o
 
Posts: 33
Joined: Sat Aug 02, 2008 11:46 pm

Re: Aggregate Player Report

Postby Flag_Hippo » Thu Nov 04, 2021 6:20 am

What specific filter are you using?
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Aggregate Player Report

Postby o0Q0o » Fri Nov 05, 2021 12:24 am

Thank you for your time and attention.

I’m using My Reports > New Report > Player Report.

In the blue filters > Add New Expression Filters. I uncheck Filter on Active Player.

I add the filter str_player_name in(), where I have several player names. The query successfully returns data for the players I list.

I would like to have the report produce one row for each position ~ BTN through BB. However the report shows six rows per player.

For the report I would like, each row would be the aggregate for all players at a position. So all players would be represented in the BTN row.

Does this answer your question? Can this be done?
o0Q0o
 
Posts: 33
Joined: Sat Aug 02, 2008 11:46 pm

Re: Aggregate Player Report

Postby Flag_Hippo » Sat Nov 06, 2021 6:51 am

Use an expression in this format instead:

Code: Select all
player.player_name = 'name1' OR player.player_name = 'name2'
Flag_Hippo
Moderator
 
Posts: 14441
Joined: Tue Jan 31, 2012 7:50 am

Re: Aggregate Player Report

Postby o0Q0o » Tue Nov 09, 2021 10:14 pm

Thank you so much. Worked perfectly.

Would never have figured out the correct format. Very glad I asked. Thank you.
o0Q0o
 
Posts: 33
Joined: Sat Aug 02, 2008 11:46 pm


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 30 guests

cron
highfalutin