Date Beast mode

NFerna · 2024-04-23T09:16:40+00:00

There was an error rendering this rich post.

Hi everyone,

I have a pivot table which contains plan data. The key point is we need to allow one month post plan completion to allow for data collection and input.

Country	Plan Name	Start Date	End Date	Status	Delivered data available
Austria	Plan 1	1st Jan 2024	1st March 2024	COMPLETED	YES
Malta	Plan 2	1st Jan 2024	1st June 2024	LIVE	NO

In this example, i have used a beast mode to populate status if end date is before current date then completed, else live. I am having issues creating the beast mode for the "delivered data available" column. The logic is:

If campaign end date +1 month, is before current date, then YES, else NO (e.g. if plan end date is 1st March, data is available from 1st April). is this possible as a beast mode and how would I go about formulating this?

Thanks!

Find more posts tagged with

Visualization

Magic ETL

Table

Beast Mode

Accepted answers

twaldron

You should be able to use a beast mode like this:

CASE
WHEN ADDDATE(`End Date`, INTERVAL 1 month) <= CURDATE() THEN 'Completed'
ELSE 'LIVE'
END

All comments

twaldron

You should be able to use a beast mode like this:

CASE
WHEN ADDDATE(`End Date`, INTERVAL 1 month) <= CURDATE() THEN 'Completed'
ELSE 'LIVE'
END