By the end of this section you will be able to:
- Create a dashboard with multiple elements
- Apply filters on dashboard charts
- Apply sort orders on dashboard grids
...
- Open the configuration form for the view
Overall Debt Levels
- Set the Background Filter to
Last 40 days
- Save your changes to the view
- Create a new dashboard, called
Debt Investigation
- Drag the view
Overall Debt Levels
onto it - You will see that the data appears with the filter
Last 40 days
applied, to check this:- Press - this will show that only 102 records are now shown
- Add a new filter:
- Name:
Cash Only
- Conditions:
PaymentMeans
equalsCASH
- Name:
- The resulting data set will contain records with
PaymentMeans
=CASH
and within the last 40 days (34 records showing)
...
- Add a filter to the view
Overall Debt Levels
on the dashboardDebt Investigation
:- Name:
select Payment Means
- Conditions:
- Where ALL the following are true
PaymentMeans
equals_prompt.PaymentMeans
- Press the ABC button - this will now say fx
- Where ALL the following are true
- When you have completed all these details press
- Name:
- A form will pop up prompting you to enter a value – type in
CHQ
and press OK - The data will refresh to show entries for payment means
CHQ
(34 records showing)
...