Linked views with multiple driving views

You can create a linked view with more than one driving view. That is, you can use several data sets to build up a set of criteria to filter data on other views (driven views) on the same dashboard.

• Create a new model Dashboards and Forms 09, 10: Linked Views and presentation
• Drag the datasource Inventory DB onto the model
• Create database collectors and streams to read in all data from the following tables in this datasource:
  • SOURCE_PUBLISHER_LIST
  • SOURCE_BOOK_SUBJECT
• Run both streams to load data into PhixFlow

A file containing a list of books can be found in the input files, at:
…\inputData\Books\BookList.xlsx

• Add a File Collector to your model
• Call this: Book List
• Navigate to the directory …\inputData\Books
• Select the file BookList.xlsx – and complete the automatic File Collector and Stream configuration
• Run your stream to load the book list into PhixFlow
• Create a simple grid view on each of these streams to display all columns and all rows
  • Give the view on the stream Book List the name: Book List
• Create a new dashboard Review Book List
• Drag all three views you created onto the dashboard. E.g. create a layout such as:

• Set the Element Name of the list of publishers to Publishers
• Set the Element Name of the list of subjects to Subjects
• Add a filter to the list of books:
  • Name: by Publisher and Subject
  • Conditions
    • Where ALL the following are true
    • Publisher equals Publishers.Publisher
      • Press the ABC button on both - this will now say fx
    • Subject contains Subjects.Subject
      • Press the ABC button on both - this will now say fx

Here we use the operator contains because the subjects of books may be longer than the subject names in the subject list – but the subjects of books will contain the subject name

• When you have completed all these details press
  • Set this filter to be applied on the view in the dashboard:
    • In the banner press
    • Press - Show chart details
    • In the chart parameters configuration form:
      • Tick the flag Use Custom Default Filter
      • Select the filter by Publisher and Subject
      • Press - Apply
      • Press - Close
• Click on a row in the list of publishers and on a row in the list of subjects
• Press - Update the dashboard using the selected rows on either of the driving views
• You will see list of books update to show only books that are by the selected publisher and on the selected subject

Passing a list from a driving view

You can pass in a list of selected records from a driving view to use in a filter:

• Edit the filter on the list of books:
  • Update the condition on publisher, make this:
    • Publisher is in Publishers.Publisher
  • Press
• Select several publishers and a subject and press on either of the driving views
• You will see list of books update to show books that are by the selected publishers and on the selected subject