Earned ongame points in sessions

[lmx2k5]

anyone has report for Ongame points earned for each played session?

Can u point me into direction how to create it (which section at least) ?

[WhiteRider]

If you want to do it per session you would use the section 'holdem cash session', but to get an overall figure you would use 'holdem cash player statistics'.

There are a few Custom Stats for this kind of thing for other sites floating around, have a look in the Repository. I think there is one for Full Tilt rakeback which would give you a good start.

[lmx2k5]

thanks, I will give it a try

[lmx2k5]

I think I need holdem cash session, but for ongame I need only to count those hands, where rakeback is at least 0.1$ and include pot player was involved, not only winning. So i feel that I need to sum amt_rake in holdem_hand_summary table for session

[WhiteRider]

OK, that sounds good.
If you want to count the hands where the rake is over 10c, you should use the structure:
sum ( if[holdem_hand_summary.amt_rake > 0.1, 1, 0] )
..like most of the other statistic-type stats.

[lmx2k5]

I made simple stat, as you said, added some stats like table name to report, but when I run report I got error:
Reason: Fatal Error (ERROR: column "holdem_table.table_name" must appear in the GROUP BY clause or be used in an aggregate function )

Any Ideas?
thanks

[WhiteRider]

You're using section 'holdem cash session' in the Reports tab too, yes?
Does this happen if you don't add your new stat to the report?

[lmx2k5]

yes, I am using "HOldem Cash Session" for report. It happens when I add any existing stat and my new stat.
also if I add only my field to report, there is nothing displayed

[WhiteRider]

Try adding your stat to the Sessions tab's 'Sessions' report. Click the little wrench/spanner icon to the right of the report and double-click your stat.
Does that work?

I'll have a quick go at building your stat and see if I can get it to work..

[lmx2k5]

adding to session tab results in same error.
May be I am missing something in Configure stats options?