Drawback Assertion: You will need to be capable of examine one month or yr to a different and be certain that they’re equal. This requires us to both conceal the present month from a card because it isn’t full, or present the exercise in every month by means of the identical cut-off date. For instance, if it’s the 15th of the month, simply present the primary 15 days of exercise in every month. We didn’t wish to manually modify playing cards every month or have to clarify why a month seems so totally different from one other month. Resolution Assertion: I used to be capable of clear up this drawback by creating two totally different beast modes for the 2 totally different conditions. If I wish to exclude the present month from a card, I create a beast mode that appears on the date within the dataset and checks to see whether it is lower than or equal to the final day of the present date’s earlier month. Whether it is, then I assign it a price of “embrace”, in any other case I assign it a price of “exclude”. I put this beast mode in my filter and filter to incorporate. Right here is the beast mode: Beast Mode for together with accomplished months CASE WHEN `EntryDate` <= LAST_DAY(DATE_SUB(CURRENT_DATE(), interval 1 MONTH)) THEN ‘Embody’ ELSE ‘Exclude’ END If I wish to solely present exercise by means of the identical cut-off date every month, I make the most of the DAYOFMONTH perform to guage whether or not the day is lower than or equal to right now’s day. I then embrace or exclude and drag it into the filter similar to my different beast mode. This permits us to see how the present month is trending in comparison with the identical cut-off date as earlier months. Right here is the beast mode: Beast Mode for together with solely as much as the identical cut-off date of every month CASE WHEN DAYOFMONTH(`EntryDate`) <= DAYOFMONTH(CURRENT_DATE()) THEN ‘Embody’ ELSE ‘Exclude’ END Demo: I created a video that demonstrates use every perform:
