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

Create a filter using an expression

• Open the model Dashboards and Forms 01-08: Views, filters and dashboardsOpen the view dashboard Debt levels by payment means 2 from the stream Overall Debt Levels (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 Image Modified
2. Press Image Modified
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

...

1. • 1. equals - from the drop down list that appears, select greater than

     2. Enter this formula

...

1. • 1. , which will take the current date, and then go back 40 days

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

This formula will take the current date, and then go back 40 days

1. • 1. 
        

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

     3. Save your changes the stream view configuration form

2. When you have completed all these details press 

...

1. Image Added.
2. Your grid should now show only results from the last 40 days.

Set default filter on a view

Since the view Debt levels by payment means 2 is too cluttered to be useful with all results showing, you decide to make the filter Last 40 days, that you created in the previous exercise, the default filter for this view:

1. Open the stream view configuration form for Debt levels by payment means 2
2. Set Default Filter to Last 40 days
3. Press Image Modified

Close then open the view again – you will see that the filter has been automatically applied.Go into App mode to see the results

Using the same filter on other views

You can use the filter you created in the previous exercise on any other view defined on this streamthe underlying stream (Overall Debt Levels), but first you must associate the filter with the view:

...

1. Open the dashboard Debt levels by payment means
2. Open the stream view configuration form for the view Debt levels by payment means
3. Go to the Filters section
4. Press Image Modified
5. Drag the filter Last 40 days into the list of filters for this view
6. Press Image Modified
7. Go into App mode

...

1. In the dashboard, apply the filter Last 40 days

...

...