Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

By the end of this section you will be able to:

...

To recap the steps in the video:

  1. Create a new dashboard Debt Analysis
  2. Add a horizontal bar
  3. Add a vertical bar in the top pane
  4. Open the model Dashboards and Forms 01-08: Views, filters and dashboards
  5. Open the stream configuration form for Overall payment levels
  6. Drag the view Debt totals by payment means into the top left pane
  7. Drag the view Overall Debt Levels into the top right pane
  8. Open the stream configuration from for Overall payment levels
  9. Drag the view Overall payment levels into the bottom pane

To link the top two views:

...

To link the top left view and the bottom view:

  1. Get the element name of the top left view: right click, and go to Dashboard Options → Show Element Details
  2. Copy the element Name
  3. Create a filter on the bottom view (Overall payment levels):
    • Name: Link to Payment Means
    • Conditions
      • Where ALL the following are true
      • PAYMENT_MEANS equals Debttotalsbypaymentmeans.PaymentMeans
      • Press the ABC button - this will now say fx
    • When you have completed all these details press Image Modified
  4. Set this as the background filter on the view:
    • Right click on Overall payment levels on the dashboard and go to Show the Stream View Configuration
    • Tick the flag Use Custom Default Filter
    • Set Background Filter to Link to Payment Means
    • Press OK

Click on a row in the top left driving view. You will see the other two views update to show only the rows for the payment means selected in the driving view

...