Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
First, https://community.dataiku.com/t5/Using-Dataiku/Dynamic-date-filter/m-p/6171#M3709 will not work for my situation because I do not have a date field that will always contain the current date.
I need to build a filter that will change based on the date the report is run. The filter is a lagged value based on the current date [between (current date - 21 days and current date -14 days)]. I have solutions outside of DSS, but not within. The reason for a within DSS solution is that I can automate the process with a dynamic filter for interim reporting.
Thank you in advance for any assistance.
Hi @JimCreech ,
You can use the date functions in DSS formula in some recipes for example the prepare recipe
https://doc.dataiku.com/dss/latest/formula/index.html#date-functions
One of the other ways we do it is,
we create a scenario and add a define PROJECT variables or define SCENARIO variables step
and then use the DSS forumla to get the date range as below basis the current date.
The variables ${start_date} and ${end_date} can then be used across recipes.
But yes everytime you would have to use to the scenario to run your flow.
Thank you. I will try this along with Ashley's
Hi @JimCreech ,
You may also want to check out dynamic date filters in the Prepare's 'filter rows/cells on date' processor. There you can set a filter to run against a date range that is relative to when the recipe is run (last N days, next N days, etc). This will let you run a relative date filter with one condition.
For the one you've outlined with two conditions "between 14 and 21 days ago", you might try a 'filter rows/cells with formula' processor with a formula like diff(now(), date_field, 'day')>14 && diff(now(), date_field, 'day')<21, modifying the >/< if you want the endpoints of the range to be inclusive or exclusive.
Cheers,
Ashley
Thank you. I will try along with Neuron's