how do i use a case when statement in a saved sear...
# suiteanalyticsk
KnotKnick
03/31/2020, 3:56 PMhow do i use a case when statement in a saved search to pull data between ‘11/01/2019’ to ‘11/30/2019’ ?
k
KevinJ of Kansas
03/31/2020, 4:00 PMWhy does this need to be a case statement and not standard functionality?
k
KnotKnick
03/31/2020, 4:13 PMi’m trying to get all the taxes collected on a monthly basis for the last 5 months, i need to create buckets of months in the result
KnotKnick
03/31/2020, 4:14 PM11/01/2019 to 11/30/2019 above was just an example
k
KevinJ of Kansas
03/31/2020, 4:15 PMDoes it have to be in seperate columns? Or can you have the months repeated in the rows?
k
KnotKnick
03/31/2020, 4:17 PMbasically the result has to be like this:
Tax_Nov19 | Tax_Dec19 | Tax_Jan20 | Tax_Feb20 | Tax_Mar20
KnotKnick
03/31/2020, 4:17 PMin a single row
k
KevinJ of Kansas
03/31/2020, 4:18 PMfair enough - just know case statement is gonna suck...
KevinJ of Kansas
03/31/2020, 4:19 PMKevinJ of Kansas
03/31/2020, 4:20 PMsomething like this:
Copy code
case when {date} BETWEEN TO_DATE ('2020/02/01', 'yyyy/mm/dd')
AND TO_DATE ('2020/02/29', 'yyyy/mm/dd') then {amount} else 0 endKevinJ of Kansas
03/31/2020, 4:20 PMdoesn't look as hard as I first thought.
KevinJ of Kansas
03/31/2020, 4:21 PMnote haven't actually tried it
k
KnotKnick
03/31/2020, 4:25 PMyep, that was it! thanks a lot!