Knowledgebase : Report Filters
(date_time within (substr(epoc_to_date_time(now()-24*60*60), 0, 11) . " __:__:__"))
(date_time > date_time_to_epoc(substr(epoc_to_date_time(now()-7*24*60*60), 0, 11) . ' 00:00:00'))
(date_time > date_time_to_epoc(substr(epoc_to_date_time(now()-8*24*60*60), 0, 11) . ' 00:00:00'))
((hour_of_day within '7') and (hour_of_day within '8') and (hour_of_day within '9') and (hour_of_day within '10') and (hour_of_day within '11') and (hour_of_day within '12')) using this table of hours, and hour_of_day values: 0 = "mid...
To compare two time periods, create a new reports with at least two elements.For the first element add a report element filter for the last 7 days (excluding today):(date_time > date_time_to_epoc(substr(epoc_to_date_time(now()-8*24*60*60), 0, 11) . '...
(date_time >= ( include 'templates.shared.util.date_time.get_weekday'; include 'templates.shared.util.date_time.get_month_as_number'; int t = now(); string weekday = ''; while (weekday ne 'Su') ( bool m = matches_regular_expression(epoc_to_date_time(...
(date_time >= ( include 'templates.shared.util.date_time.get_weekday'; include 'templates.shared.util.date_time.get_month_as_number'; int t = now(); string weekday = ''; while (weekday ne 'Su') ( bool m = matches_regular_expression(epoc_to_date_time(...
(date_time within ("__/" . substr(epoc_to_date_time(date_time_to_epoc('01/' . substr(epoc_to_date_time(now()), 3, 8) . ' 00:00:00') - 1), 3, 8) . " __:__:__"))