I need a solution where I need to set date filter to automatically set filter for days before a set date.
where you can have a filter for a date, where you can enter a specific date and then a filter is applied for all dates prior to this date?
For example, we have a hold that we know will close on Oct 1. If I enter Oct 1,2020, then the filter should automatically select all orders with ESD (estimated ship dates) available in the filter before this date.
Hi, you can set the date using a variable or user selections in date field.
To retriueve date before the selcted date you can use set analysis
- Using variable: Sum({<DateField={"<=$(VariableName)"}>} Value)
- Using field: Sum({<DateField={"<=$(=Max(DateField))"}>} Value)
To use a variable you can use the variable object on Custom objects -> Dashboard bundle. To use a variable a normal filter can be used, also the Date picker object inside the same Custom objects -> Dashboard bundle.
