2 Replies Latest reply on Mar 30, 2016 11:27 AM by msa s

    Using dynamic parameters across data source.

    Sarwagya Jha

      Hi ,

       

      I am new to tableau desktop. I am trying to develop a tableau dashboard. I have two data data source using sql query.

      First query is the primary query. Second one is the secondary query using the parameters from the primary query.

       

      my primary query:

      Select audit_no,facility_code,cocl_code from oa_audits;

       

      Secondary_query:

      select * from oa_audit_perform where audit_no=:audit_no and fac_code=:cocl_code;

       

      Thanks for help in advance.

      Please let me know in case more details are required.