I have a data set of invoices that I want to compare in a bar graph where one bar is October and the other bar is November. I suppose I can do this with a beast mode but I think my syntax is off.
Case when Title
LIKE '%OTT%' Then 'OTT'
AND MONTH(Date
) = CURRENT_DATE(MONTH(Date
)) THEN 'Current Month'
Case when Title
LIKE '%OTT%' Then 'OTT'
AND MONTH(Date)
= CURRENT_DATE(MONTH(Date
))-1 THEN 'Previous Month'
ELSE ''
Can someone help me with this beast mode?