Create Bar Chart with Current Month Vs Previous Month?

OllyB · 2024-12-05T09:45:23+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

Analyzer

Admin

API

Activity Log

Alerts

Accepted answers

ggenovese

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

All comments

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