Skip to main content
Question

Report Using Multiple Tables

  • March 3, 2020
  • 0 replies
  • 332 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • March 4, 2020
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
------------------------------
Terms & ConditionsAccessibility statement