Custom Report: Tournaments by day of week and time

[WhiteRider]

Following up from this post on our 2+2 forum I have built a custom report which lists tournaments by day of the week played and the hour in which they started.

I have attached this report to this post.

HTPS - Tourney DOW+Hour.zip

(1.03 KiB) Downloaded 172 times

Extract the file from the zip and import it to PT3 using the Import button on the Reports tab.

This report groups the tournaments starting in the same hour and day of the week together.

If you want to filter it (to see just your Tuesday evening column, Scott) you can add a custom filter like this:
str_tourney_start_dow_hour = 'Tue, 07pm'
..or whatever the start hour is.

Note: the stat itself doesn't have that kind of value - I had to use numerical columns for the stat's Value Expression to get the report to sort correctly. If you use str_tourney_start_dow_hour in the Value Expression then the report will be sorted alphabetically so the days won't be in the right order. This means that a filter like #Date DOW-Hour# = 'Tue, 07pm' will not work.

You could tweak this report to split it by minutes if you want it that accurate but this will leave to a much more complex report, and if a regular tournament were to start a minute or two later they wouldn't be grouped together.