1 Reply Latest reply on Feb 10, 2017 10:02 AM by Joshua Vogel

    Default filter to Record with the Index of 1. Customer - Contract - Contract Details

    Joshua Vogel

      My data source consists of 4 tables:

      • customer
      • contract
      • contract_details
      • contract_use

       

      They are joined using left joins:

      • customer -> contract
      • contract -> contract_details
      • contract -> contract_use

       

      The aim of the dashboard is to:

      1. Filter on an individual customer
      2. Show a list of all related contracts
      3. Show contract details for a single contract, defaulting always to the contract with the lowest ID
      4. Show contract use for a single contract, defaulting always to the contract with the lowest ID

       

      I also want this dashboard to allow for the user to select other contracts and see the details and use for those contracts.

       

      Message was edited by: J Vogel Added a packaged workbook and edited text.