Report that shows stats by number tables active

[smzzzx]

Hi, I’ve built a custom report that shows how many tables Hero was playing at the same time for each hand.

It works by using custom PostgreSQL objects in the database. The report reconstructs Hero’s playing sessions from PT4 session data, merges overlapping sessions into a timeline, and then uses a custom function to return the number of active tables at the timestamp of each hand. That value is then used as a custom PT4 stat, so I can groupp results by 1 table, 2 tables, 3 tables, etc.

The main limitation is that the table count is reconstructed rather than stored directly by PT4, so it is an estimate based on session overlap. Very short gaps or imperfect session boundaries can occasionally create an incorrect count, but over large samples it seems accurate enough to be useful.

I’ve now run into one issue when combining multiple sites. The player identities are linked under the same alias, but hands from sites using different game currencies are appearing on separate rows in the Player report. For example, I get one Tables = 1 row for one site and another Tables = 1 row for another site, instead of having all sites combined into a single Tables = 1 row, like in screen shot attached.

Do you know what PT4 is using to keep these rows separate? Is there a way to make the report combine all aliased player identities onto the same Active Tables rows regardless of the game currency?