Create Bar Chart with Current Month Vs Previous Month?

OllyB
OllyB Member
in Beast Mode

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?

Tagged:

Best Answer

Answers

  • ggenovese
    ggenovese Contributor
    Answer ✓

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

  • ArborRose
    ArborRose Coach

    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

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Categories