Using data from multiple tables in reports
Hi QuickBase community - This is likely a very simple query but one which I can't work out as yet so instead of pulling my hair out anymore I decided to put it to you :)
I have a table called '...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou will need to have a Parent table called Brand Tiers. It needs to have every combination possible of Brands and Tiers.
The Key field needs to be a text field which is the concatenation, say hyphen delimited concatenation, of the Brand and the Tier. There are ways to make this easier to maintain but I can't really tell how many different brands you have so I don't know how difficult this is to maintain manually. If I read your post literally you only have two brands.
Then you can make a relationship to the Customer Sync table to summarize the total counts of customers in each bucket, and the also a relationship to deployments to count the deployments.
Each child table will have a formula reference field to calculate the [Brand -Tier] value as the retrench field value to the Parent table.
The percentage calculation will be done up on the Brand Tier table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
The Key field needs to be a text field which is the concatenation, say hyphen delimited concatenation, of the Brand and the Tier. There are ways to make this easier to maintain but I can't really tell how many different brands you have so I don't know how difficult this is to maintain manually. If I read your post literally you only have two brands.
Then you can make a relationship to the Customer Sync table to summarize the total counts of customers in each bucket, and the also a relationship to deployments to count the deployments.
Each child table will have a formula reference field to calculate the [Brand -Tier] value as the retrench field value to the Parent table.
The percentage calculation will be done up on the Brand Tier table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Hi Mark,
Oof! That sounded slightly more complicated than I thought..
I have 182 brands sitting in Tiers 1-3 which would be where I want to see which of those have deployments.
Is there a simpler way to do it based on that volume?
------------------------------
M
------------------------------
Oof! That sounded slightly more complicated than I thought..
I have 182 brands sitting in Tiers 1-3 which would be where I want to see which of those have deployments.
Is there a simpler way to do it based on that volume?
------------------------------
M
------------------------------
- MarkShnier__YouThere are automated ways to maintain the table.
You can initiate the table manually, using excel or via a summary report exported to that table.
For ongoing maintenance, you can set up an Automation to create a new parent whenever an orphan deployment is created.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Thanks for your help in trying to explain, Mark - Still sadly none the wiser! Annoying this is not easier to do (trying to drive my business away from spreadsheets but this would take seconds to do in Excel/Google Sheets!!!)
------------------------------
M
------------------------------- MarkShnier__YouThere may be new formula functions coming in about a year to make this easier. But right now we are where we are.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------