"SUM" Function in "HOLDEM CASH HAND"

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

"SUM" Function in "HOLDEM CASH HAND"

Postby Borsaci007 » Tue Dec 14, 2010 8:51 am

Everytime I try to use the Sum Function in the "holdem cash hand" section, poker tracker is running and running without finding an ending.

For examble:

sum(if[holdem_hand_player_statistics.id_hand > 0, 1, 0])

This formula is working without problems in "hold cash player statistics" section, but not in the "holdem cash hand" section.

Can you help me?
Borsaci007
 
Posts: 17
Joined: Wed Jan 27, 2010 5:30 pm

Re: "SUM" Function in "HOLDEM CASH HAND"

Postby kraada » Tue Dec 14, 2010 9:38 am

That's because in the Hand section the stats are for individual hands only. It makes no sense to try and count how many hands a player played during that one hand, and hence that construction will not work.

For more on how the various sections work, please see the Sections portion of the Tutorial: Using Custom Reports and Statistics.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 11 guests