Comparing Month and Year Data using Beast Modes

Dilemma Assertion: It is vital to be in a position to examine 1 month or 12 months to yet another and make sure that they are equal. This demands us to either hide the recent month from a card due to the fact it isn’t full, or present the exercise in each thirty day period by the same position in time. For example, if it is the 15^th of the month, just clearly show the 1st 15 times of exercise in every single month. We did not want to manually regulate cards every single month or have to make clear why a month looks so diverse from a further month.

Remedy Assertion: I was equipped to remedy this trouble by making two distinct beast modes for the two different circumstances. If I want to exclude the latest thirty day period from a card, I build a beast method that appears to be at the date in the dataset and checks to see if it is much less than or equal to the last day of the present date’s prior month. If it is, then I assign it a worth of “include”, or else I assign it a price of “exclude”. I set this beast mode in my filter and filter to contain. Below is the beast method:

Beast Method for including completed months

Scenario WHEN `EntryDate` <= LAST_DAY(DATE_SUB(CURRENT_DATE(), interval 1 MONTH)) 

THEN ‘Include’

ELSE ‘Exclude’

END

If I want to only show activity through the same point in time each month, I utilize the DAYOFMONTH function to evaluate whether the day is less than or equal to today’s day. I then include or exclude and drag it into the filter just like my other beast mode. This allows us to see how the current month is trending compared to the same point in time as previous months. Here is the beast mode:

Beast Mode for including only up to the same point in time of each month

CASE WHEN DAYOFMONTH(`EntryDate`) <= DAYOFMONTH(CURRENT_DATE()) 

THEN ‘Include’ 

ELSE ‘Exclude’ 

END

Demo: I created a video that demonstrates how to use each function: