Is there a way to get a "previous 7 rolling days" ...
# general
d
Is there a way to get a "previous 7 rolling days" filter on reports? We do not have that option but we need it to make a report that we want.
d
With a saved search, you can use Formula(Date) {created}+7 before today or similar.
t
Yeah something like CASE WHEN {createddate} BETWEEN ({today}-7) AND ({today}-1) THEN 1 ELSE 0 END