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

ggenovese

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

ArborRose

I agree with @ggenovese. You may want to look at using the period over period charts. As for your beast mode, maybe changing your condition logic to something like:

CASE 

    WHEN Title LIKE '%OTT%' AND MONTH(`Date`) = MONTH(CURRENT_DATE()) THEN 'Current Month'

    WHEN Title LIKE '%OTT%' AND MONTH(`Date`) = MONTH(CURRENT_DATE()) - 1 THEN 'Previous Month'

    ELSE ''

END