Custom report problem

[SathOkh]

Hello,
I have problem with creating custom report: I created it like on screen:


but I'm playing mostly sit&go and I want group results not only by buy-in and tourney type(limit), but also by number of players in tourney(I've played 6 max and 10 max, I want results from it separated). Could someone help me and tell how can I do this? I can't see such stat in Holdem Tournament Tournaments. Such stat exist in Holdem Tournament Tournament but it doesn't group tourneys ;/

Thank You in advance

[kraada]

Add the Table Type statistic and that shoudl break things down as you want to see them.

[SathOkh]

Nope, it doesn't help. The only result is additional column. I need to make report(like on screen) where data are group by 3 stats: buy-in,tourney type, and entries to tournaments. The main reason is I want to have it looks like:
---------------------------------------------
Buy-in Type Entries Other stats
----------------------------------------------
0,10$ No limit 6 xxxxxxxx
0,10$ No limit 10 xxxxxxxx
0,20$ No limit 6 xxxxxxxx
0,20$ No limit 10 xxxxxxxx
0,20$ Limit 6 xxxxxxxx

[kraada]

You'll need to create a stat for this, but it isn't too difficult.

Click Configure --> Configure Statistics, click on Holdem Tournament Tournaments (it's the last one on the list) then click Columns.

Click on the cnt_players column and click the Dup button. Change the name of the new (duplicated) column to cnt_players_gb, and check the "Group By" box. Then go to the Statistics tab.

Click on "Average Players" and Dup. Change the title to Total Entrants, change the value expression to just cnt_players_gb and go to the Format tab. Change the title to whatever you'd like to see (Entrants), then change the format expression to format_number(cnt_players, 0, true, false) and then save and apply. Add your new stat to your report and you'll be all set.

[SathOkh]

I tried do like You said, but I have a problem with this:



Error message in polish says: "Error: agregats can't be used in GROUP BY clause". Is it any way to workaround this problem?

[kraada]

Erm, shoot I should've realized that. No, you can't use sum() in a group by column. So the easiest thing is going to be for you to either label your tournaments appropriately (you can label tournaments as SnG (6 max) and then my previous step will display them as differently from SnG). You would do this via the Tournaments --> Enter Results window; if you sort by players there (just click the top of the column) the changes should be fairly easy to implement (just remember when you save to click "changed settings only" otherwise the buyins will get overwritten). Otherwise, you'd need to do this report in Tournament Holdem Tournament.

[SathOkh]

Thanks for help, I've changed 6 max tournaments to SnG (6 max) and now, it works with Your tips.