Last full day only

Hello, 

 

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

     

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

Answers

This discussion has been closed.