- 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.
...
- Open the dashboard
Debt levels by payment means
- Open the stream view configuration form for the view
Debt levels by payment means
- Go to the Filters section
- Press
- Drag the filter
Last 40 days
into the list of filters for this view - Press
- Go into App mode
- In the dashboard, apply the filter
Last 40 days
Panel |
---|
In PhixFlow, any filter defined on a view on a stream can be used on any other view defined on that stream. |