Last full day only

Dpritykin

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

Godiepi

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

 

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

Godiepi

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

 

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

Dpritykin

Thanks 

Dpritykin

Is there way to get rid of the today's collumn? 

Godiepi

Make sure to add the beastmode as a Filter so that the last Date does not show up at all