Discussions

Expand all | Collapse all

Report Using Multiple Tables

  • 1.  Report Using Multiple Tables

    Posted 03-03-2020 11:28
    Hi Everyone,

    Is there a way to create a chart, that pulls in data from multiple table?  I'm trying to create a Pie chart showing a count of On Time / Late proposals.  This information is stored on four different tables.

    Any help would be appreciated.

    ------------------------------
    Terri Wells
    ------------------------------


  • 2.  RE: Report Using Multiple Tables

    Posted 03-03-2020 12:14
    No, there is not way to build a report from multiple tables.  

    What you would need to do is to create a night;y process to copy the records from each of the 4 tables into a central table and you would need to set up a Key field to preface the record ID of each table with a name for the stable.  YOU would then need to set up a relationship so as to be able to detect deleted record in the source table.

    Then each night an Automation would need to run to repopulate the target table by running 4 saved table to table imports and delete any target table records where their source record was deleted.

    So, yes possible with some setup.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Report Using Multiple Tables

    Posted 03-04-2020 07:12
    Terri,

    You need a different tool to do this.  There are three basic ways to tackle it.

    1) Export the data using the Save as a Spreadsheet feature.  


    You will need multiple exports from each table.  Consolidate them into a Excel workbook and build your pie chart.  This is "free" but obviously does not refresh or stay up to date.


    2)   Quick Base has MS PowerBI connector

    https://help.quickbase.com/user-assistance/power_bi_with_quick_base.html

    Without knowing more about your architecture and the complexity of blending your data, the connector is not guaranteed to be flexible enough to solve the issue. However it probably will do the job if this a simple report.

    3) SQLization of your Quick Base data.  This is where we extract the data from Quick Base, table by table, index it and build a new SQL DB. Now instead of a connector you can use any BI/BA tool like Tableau or PowerBI to create any report that you can dream of.  You also can schedule your refresh so that reports stay current.   Reach out and I will be happy to discuss this in more detail.





    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------