I have tried the configure stats without success to do the following: I would like to be able to display in the HUD the total amount won by hero for all sessions on a particular site for the current system date.
Is this possible? I thought I was getting close by creating a column that looked like this: sum(if[dateextract_date[datefix_fromutc[ holdem_table_session_summary.date_start ]]=SYSDATETIME ()
, holdem_table_session_summary.amt_won, 0]) - but this is apparently not valid sql. Not sure if I need to change the syntax for SYSDATETIME (), or if the whole thing is no good.
Actually, I'd like to be able to something very similar for mgr also. I should be able to figure this out once I can do the above though.
Thanks for any help you can offer, and sorry if I could of found this by searching more - I did try.
