Comparing Month and Year Data using Beast Modes

Issue Statement: It is critical to be in a position to evaluate 1 month or yr to one more and assure that they are equal. This needs us to both hide the recent thirty day period from a card since it isn’t full, or display the activity in every single month through the very same place in time. For case in point, if it is the 15^th of the month, just display the very first 15 days of activity in each month. We didn’t want to manually regulate playing cards each and every month or have to make clear why a thirty day period seems to be so distinct from a different month.

Answer Assertion: I was equipped to solve this dilemma by producing two unique beast modes for the two unique circumstances. If I want to exclude the current thirty day period from a card, I generate a beast method that looks at the date in the dataset and checks to see if it is significantly less than or equal to the last day of the current date’s past month. If it is, then I assign it a worth of “include”, usually I assign it a value of “exclude”. I place this beast method in my filter and filter to consist of. Listed here is the beast mode:

Beast Method for such as concluded months

Circumstance 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: