PhixFlow Help

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

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
  • No labels