Forum Discussion

TerriWells's avatar
TerriWells
Qrew Trainee
5 years ago

Report Using Multiple Tables

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 ...
Relationships
reports and charts
DonLarson's avatar
DonLarson
Qrew Commander
5 years ago
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
------------------------------