Hands played today

[Alergenic]

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.

[4StarGen]

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 ])

[Alergenic]

I got Invalid Value Expression when trying this.

[4StarGen]

[Alergenic]

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).

[kraada]

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

[Alergenic]

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

[kraada]

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

[Alergenic]

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.

[4StarGen]

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