If you have a situation where one project record has three different milestones deep feels on the same record and that kind of reporting is important to you then you need to change the structure of your application.
The correct structure for that would be one project as many mile stone dates. And your summary report would be on the mile stone dates table and the recording could be simple.
If there are different types of milestone dates for example project started or construction started or sign off complete, then on the mile stone dates trial table there would be a tape filter identify what type of milestone date it was.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 08-09-2022 11:39
From: Mark Shnier (Your Quickbase Coach)
Subject: New App
On the other hand, if you were saying that it's record just has a single mile stone deep then just do a summary report to group Rose by city and then enable column grouping by milestone day.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 08-09-2022 11:29
From: Mark Shnier (Your Quickbase Coach)
Subject: New App
Let me see if I can respond by tation, because I'm on a bicycle now.
Are you saying that each record has three different milestone dates on it and hence the very same record head and dad getting summarized into any of those three columns?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 08-09-2022 11:09
From: Mike Sanders
Subject: New App
All of the data is in one table. I need to sum one column (for 3 different milestone dates, depending on if they are empty or not) and then put those sums in a row for each of 5 cities. I want the result in this format:
Market | Date 1 | Date 2 | Date 3 |
Denver | 17 | 16 | 4 |
Boston | 0 | 0 | 0 |
Chicago | 0 | 0 | 0 |
Dover | 0 | 0 | 0 |
Evansville | 0 | 0 | 0 |
TOTAL | 17 | 16 | 4 |
I apologize for not explaining this very well.
------------------------------
Mike Sanders
Original Message:
Sent: 08-09-2022 10:49
From: Mark Shnier (Your Quickbase Coach)
Subject: New App
If you mean that you have data and separate tables in an application then no it is very difficult to combine that information.
Imagine if you had a spreadsheet with different tabs and each tab had completely different information in order to combine that becomes very tricky
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 08-09-2022 10:23
From: Mike Sanders
Subject: New App
Thanks Mark, is it possible to take the results of multiple summary tables and combine them into a single table?
------------------------------
Mike Sanders
Original Message:
Sent: 08-05-2022 18:07
From: Mark Shnier (Your Quickbase Coach)
Subject: New App
The items table should just have three fields for:
- Market (multiple choice or lookup from a relationship) ,
- Qty
- Type (multiple choice if there are just a few choices).
Then use a summary report to make your report.
The config for the summary report is that group by Rows are Market and "group columns" by type.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
Original Message:
Sent: 08-05-2022 17:53
From: Mike Sanders
Subject: New App
I would appreciate any suggestions on the best way to set up a new app to be able to create this simple table:
Market | Total Items | MS 2 Items | MS 3 Items |
Houston | 17 | 16 | 4 |
Indianapolis | 22 | 0 | 0 |
Atlanta | 13 | 7 | 6 |
Miami | 0 | 0 | 0 |
Los Angeles | 0 | 8 | 10 |
TOTAL | 52 | 31 | 20 |
Each market has multiple records which have any number of items in the 3 categories. The different item types are summed to give the number shown above.
It seems like a simple table, but I haven't been able to figure it out. Please help!
------------------------------
Mike Sanders
------------------------------