i've spent a stupid amount of time trying to figur...
# suiteanalyticsa
Amanda Flynn
11/30/2018, 6:43 PMi've spent a stupid amount of time trying to figure this out, can someone help me with a simple saved search formula for 'case when transaction.date BETWEEN today - 180 and today'? (180 days ago until now)
g
Gregory Jones
11/30/2018, 7:00 PMSetting the following as Formula (Numeric) criteria should work: CASE WHEN ({today}-{trandate}) <=180 THEN 1 ELSE 0 END, and the value you'd set in the formula is '1'
g
George McMullen
11/30/2018, 7:01 PMg
Gregory Jones
11/30/2018, 7:03 PM😲 @George McMullen That is CERTAINLY getting bookmarked!
g
George McMullen
11/30/2018, 7:03 PM👍
a
Amanda Flynn
11/30/2018, 7:21 PMthank you for the replies! except i just realized i've been troubleshooting this for over an hour, and it turns out i had an extra 'e' in between. it's friday afternoon, i guess. i used 'case when {trandate} between {today} - 180 and {today}' to get amount of transactions. simple except for my humanness.
😂 1
g
Gregory Jones
11/30/2018, 7:29 PMI ran into something like that other day. Too bad i couldn't chalk it up to Friday! 😁
😂 1