Filter expression for specific day

[BloMur]

Hey,
Is there filter expression to select only specific days of the month,
lets say I would like to see results only from 1st to 15th day of the month.

[Flag_Hippo]

That would be:

Code: Select all

date_played_day < 16

[BloMur]

Is it possible to made someting similar by hours, lets say from 16:00:00 - 16:59:59

[Flag_Hippo]

There is a built-in filter for that in 'Game Details -> Dates -> Time of Day'. If you want an expression filter that is:

Code: Select all

(
     TIME '16:00' < TIME '16:59' AND
     (CAST(timezone('UTC', cash_hand_player_statistics.date_played) AS TIME) >= '16:00' AND
     (CAST(timezone('UTC', cash_hand_player_statistics.date_played) AS TIME) < '16:59'))
)
OR
(
     TIME '16:00' >= TIME '16:59' AND
     (CAST(timezone('UTC', cash_hand_player_statistics.date_played) AS TIME) < '16:00' OR
     CAST(timezone('UTC', cash_hand_player_statistics.date_played) AS TIME) >= '16:59'))

There are also 'Cash Hand Time Groupings' and 'Tournament Start Time Groupings' custom reports in the Download Warehouse.