By the end of this section you will be able to:
- Create linked views on a dashboard
Create a linked view
The following video illustrates how to create linked views:
Widget Connector | ||||||
---|---|---|---|---|---|---|
|
To recap the steps in the video
Views on dashboards can be "linked" so that the results shown in one view can be filtered based on the rows selected in a "driver" view.
...
- Name:
by Payment Means
- Conditions
- Where ALL the following are true
PaymentMeans
equalsDebtTotals.PaymentMeans
- (The expression
DebtTotals.PaymentMeans
gets the value ofPaymentMeans
from the selected record in the driving view)
- (The expression
- Press the ABC button - this will now say fx
- When you have completed all these details press
- Set this filter to be applied on the view in the dashboard:
- Right click on
on the dashboard and go to Dashboard Options → Show Element DetailsOverall Debt Levels
- Tick the flag Use Custom Default Filter
- Select the filter
by Payment Means
- Press OK
- Right click on
...
- Name:
by Payment Means
- Conditions
- Where ALL the following are true
PAYMENT_MEANS
equalsDebtTotals.PaymentMeans
- Press the ABC button - this will now say fx
- When you have completed all these details press
- Set this filter to be applied on the view in the dashboard:
- Right click on
on the dashboard and go to Dashboard Options → Show Element DetailsOverall payment levels
- Tick the flag Use Custom Default Filter
- Select the filter
by Payment Means
- Press OK
- Right click on
- Click on a row in the driving view (
Debt totals by payment means
) - You will see the other two views update to show only the rows for the payment means selected in the driving view