Show last 12 months dynamically using beast mode calculation?

Salmas

I wanted to show last 12 months from June 2020 - May 2021 dynamically using beast mode calculation.

Any help is appreciated!

Thanks in advance

GrantSmith

Hi @Salmas

You can just use the date selector on the car to select the last 12 months instead of having to utilize a beast mode:

This will give you the most flexibility with your card. You can also configure it in analyzer to select it by default.

GrantSmith

If you must use a beast mode one like this should work for your use case:

CASE WHEN `dt` >= (CURRENT_DATE - INTERVAL (DAYOFMONTH(CURRENT_DATE) - 1) DAY) - INTERVAL '12' MONTH AND `dt` < (CURRENT_DATE - INTERVAL (DAYOFMONTH(CURRENT_DATE) - 1) DAY) THEN 'Include' ELSE 'Exclude' END

I've outlined getting the first day of a month in another post which will explain this in more detail:

https://dojo.domo.com/discussion/52687/domo-ideas-exchange-beast-modes-first-last-days-of-the-month-week

I've also presented on this topic as well and you may find this video useful: https://www.youtube.com/watch?v=gO8OLpsAk4M&index=6

Salmas

Thanks @GrantSmith , it's working