Devin,
Quick Base is great at business process problems. However it's reporting capabilities are limited by having the data directly related to the other data in Quick Base.
Your simplest answer is to think through how to connect those tables in Quick Base.
A sure fire approach is to get the data out of Quick Base and into SQL. Once you have done that you can use a Business Intelligence tool like Tableau, Power BI. Watson to ask anything you want of the data. You can use Quick Base with any other data you have from accounting, marketing, or other databases.
We build a tool called Paasporter to extract Quick Base data and get it into SQL.
www.paasporter.com Quick Base is king of business process but SQL rules reporting.
Let me know if I can help.
------------------------------
Don Larson
------------------------------
Original Message:
Sent: 03-21-2018 21:09
From: Devin Devin
Subject: Creating Reports Between Removed-Relationship Tables
We work in property management. Our properties report incidents to the corporate office, and we'd like to report back to the properties on the incidents we have collected. Below is a diagram of the tables we have setup and the reporting we'd like to run. Is it possible to create a report which runs based off a distantly related table?
An equation would be something like (see diagram below):
Incident X, Y, & Z is related to Property A, and if Property A has Resource Z, then the report would return Incidents X, Y, & Z in its report. A report run for Resource Z to know the incidents at their Property A.
_">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1717580/RackMultipart20180321-80123-x5cs13-3.21.18_Incident_Regional_Reporting_Diagram_inline.png?1521666279">_