Counts backwards the specified number of days starting from the most recent midnight. Partial days are not included. Can only be used as a duration parameter in for_date_range().
To count forward, eliminate the minus (-).
Syntax
days(-x)(counts backwards x days)-days(x)(counts backwards x days)days(x)(counts forward x days)
x is required to be an integer.
Examples
If you view a column with the following formula at 10 a.m. on October 15th, the function returns the number of clicks between October 1, 12:00 a.m. and October 14, 11:59 p.m.
Clicks.for_date_range(today(), days(-14))
The following formula returns the number of clicks between October 1, 12:00 a.m. and October 7, 11:59 p.m.:
Clicks.for_date_range(date(2013, 10, 01), days(7))