Page Comparison

• Create a filter using an expression
• Set a default filter on a stream view

...

• Open the dashboard Debt levels by payment means 2 (you created this in exercise 18 Create further Stream Views)

The chart is cluttered. You will now add a filter to this view to limit the results to the last 40 days:

1. In the chart press
2. Press 
3. Configure the filter with the following details:
   • Name: Last 40 days
   • Conditions:
     1. The condition dialogue starts with Where ALL the following are true - leave this as it is
     2. Select CalculationDate
     3. Press on equals - from the drop down list that appears, select greater than

     4. Enter this formula, which will take the current date, and then go back 40 days

        Code Block
        dateAdd(now(), _DAY_OF_MONTH, -40)

        
        

     5. Press the ABC button - this will now say fx

     6. Save your changes the stream view configuration form

4. When you have completed all these details press .
5. Your grid should now show only results from the last 40 days.

...