I think you can just select the date filter and it...
# suiteanalyticsi
iSuite
04/02/2019, 9:13 PMI think you can just select the date filter and it has a pre-set
fakenews 1
a
Amanda Flynn
04/03/2019, 6:26 PMno, not on the item search, i cannot set a date as a criteria. i have to write the formula in the results tab.
m
Mark C
04/05/2019, 12:47 PMI use CASE WHEN {today} - {trandate} <= 7 THEN {whatever you want to measure} ELSE 0 END
That gives you the last 7 days if you're in a transaction saved search
a
Amanda Flynn
04/08/2019, 1:19 PM@Mark C hey, thanks! I just saw this. I needed prior week sales on an item search so I ended up using this, works great! CASE WHEN ({transaction.trandate} >= TRUNC({today} - 7 ,'IW') and {transaction.trandate} <= NEXT_DAY({today} - 7 ,'SUNDAY'))