- Create a filter using an expression
- Set a default filter on a stream view
...
- In the chart press
- Press
- Configure the filter with the following details:
- Name:
Last 40 days
- Conditions:
- The condition dialogue starts with Where ALL the following are true - leave this as it is
- Select
CalculationDate
- Press on equals - from the drop down list that appears, select greater than
Enter this formula, which will take the current date, and then go back 40 days
Code Block dateAdd(now(), _DAY_OF_MONTH, -40)
Press the ABC button - this will now say fx
Save your changes the stream view configuration form
- Name:
- When you have completed all these details press .
- Your grid should now show only results from the last 40 days.
...