PokerTracker

Hi. I am interested in stat that will show number of hands I have played the day I am playing. I can see my number of hands played n certain table with stat "Hands", but I would like to know what is my total number of hands played today on all of the tables.

Try this

Code: Select all

sum( if[ (now() at time zone 'GMT') - (interval '24 hours ') < cash_hand_player_statistics.date_played AND cash_hand_player_statistics.id_hand > 0, 1, 0 ])

I got Invalid Value Expression when trying this.

I am not shure I did everything correct. So I created new column with that formula. Then I adden New stat, that shows that new column number. When I opened the table, I got some error message, but that stat was displayed. But number is showed is actually same number that I see in Hands stat (Number of hands played on this exact table).

That shouldn't be showing lifetime hands - are you looking at a live table or the replayer?

I am looking for lifetime hands, not in replier. Stat like Hands, but for whole session.

Make sure you don't have "cache" ticked - this stat won't work right if you cache it.

Thank You! I have unchecked "cache". Now it starts without any errors, but it still shows hand number played on the particular table, not a sum of all hands played.

I don't think you can create a Hero HUD stat that displays hands played today, because PT4 queries the DB in a specifical way for Hero in order to display session stats.
I'm not aware on any workaround, so my stat work on a report but not on your HUD