Weird/Random Question about the date filter.

I have a card that is a POP trendline and is comparing current year to the previous 2 years aggregating by month

You can see that in the current month (September) there is a drop off from August because it is an incomplete month. Is there a way to show the card in this same view but just not display an incomplete current month? Possibly by using the date filter or by writing a beast mode that could be used as a filter so the most recent data would be the complete previous month?


Best Answer

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🟤
    Accepted Answer

    You could write a beast mode like this to exclude the current month

    (CASE WHEN MONTH(`date`) = MONTH(CURDATE()) and YEAR(`date`) = YEAR(CURDATE()) then 'Exclude'
     Else 'Include' END)

    Then just add this to your filters and choose Include