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:

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.

• Create a new dashboard Debt Analysis

You will drag some of the views you have created onto this dashboard, but also a view from a different stream. First, find this view so that you know what data to expect in your dashboard:

• Open the model Dashboards and Forms 01-08: Views, filters and dashboards
• Hover over the stream Overall payment levels
• Open the view Overall payment levels

The view shows the total amounts paid on each day by each payment method.

• Now return to your new dashboard, Debt Analysis
• Drag the following views onto the dashboard:
  • Debt totals by payment means from stream Overall Debt Levels
  • To the right of this, Overall Debt Levels from stream Overall Debt Levels
  • Underneath Debt totals by payment means, Overall payment levels from stream Overall payment levels

Now you will make Debt totals by payment means a driving view and link the other two views to it:

• Right click on Debt totals by payment means on the dashboard and go to Dashboard Options → Show Element Details
• Set Name to DebtTotals
• Press OK

Add a filter to Overall Debt Levels:

• Name: by Payment Means
• Conditions
  • Where ALL the following are true
  • PaymentMeans equals DebtTotals.PaymentMeans
    • (The expression DebtTotals.PaymentMeans gets the value of PaymentMeans from the selected record in the driving view)
  • 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 Overall Debt Levels on the dashboard and go to Dashboard Options → Show Element Details 
    • Tick the flag Use Custom Default Filter
    • Select the filter by Payment Means
    • Press OK

Now add a filter to Overall payment levels:

• Name: by Payment Means
• Conditions
  • Where ALL the following are true
  • PAYMENT_MEANS equals DebtTotals.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 Overall payment levels on the dashboard and go to Dashboard Options → Show Element Details 
  • Tick the flag Use Custom Default Filter
  • Select the filter by Payment Means
  • Press OK
• 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