Last full day only



I would like to create cards that show data for the past 7 full days only ( without showing today's data) and have that card update it self automaticly as the day ends. Right now the only way i can do that is through creating a new data set that allows me for this manipulation. However, that forces me to creat multple datasets with the exact same data ( one for dynamic or live data and one for static or full day data). 


Is there a way to do this on a card level rather than on the dataset level? 


Thank you

Best Answer

  • Godiepi
    Godiepi 🟣
    Accepted Answer

    You can create a beastmode to be added as a filter that reads


    WHEN `YourDate` = CURRENT_DATE() then 'No'
    ELSE 'Yes' END


This discussion has been closed.