filter data on previous day/week/month

[KevSan]

Hi everybody,

I would like to create a filter pane with variables for filtering on previous day/week or month. How could it be done ? 

And how to put the yesterday filter automatically when opening the file ?

Does someone have an idea for me? Or another way to achieve it

Thanks in advance for your answer and have a nice day.

[albertovarela · Accepted solution]

To apply the yesterday filter on opening, you could create a dynamic bookmark and set it up as default.

Identify the sheet to be the landing page,  if you already have a filter pane or table with the date field use the expression search: =yourfield=today()-1 and hit enter; if you don't have the field exposed then use the selections tool.  Then create the bookmark and set it up as default .

I hope this helps