Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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