Create Bar Chart with Current Month Vs Previous Month?

OllyB

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?

ggenovese

You can do this with period over period charts without the need for a specialized beast mode