- 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
- Private: not ticked
- Conditions:
- The condition dialogue starts with Where ALL the following are true - leave this as it is
- Press Select – from the drop down list that appears, select CalculationDate
- Press on equals - from the drop down list that appears, select greater than
- Click just to the right of greater than - an edit box will appear; enter this formula:
| Code Block |
|---|
dateAdd(now(), _DAY_OF_MONTH, -40) |
This formula will take the current date, and then go back 40 days
- Press the ABC button - this will now say fx
- When you have completed all these details press
...
- Open the configuration form for the view Debt levels by payment means
- Go to the Filters tab
- Press
- Drag the filter Last 40 days into the list of filters for this view
- Press
- Open the view Debt levels by payment means
- Apply the filter Last 40 days
View the results.
In PhixFlow, any filter defined on a view on a Stream can be used on any other view defined on that Stream. |