Skip to main content
Question

Using totals in reports

I've dabbled in Microsoft Access for many years and am used to their Querys. I'm having a dickens of a time figuring out how to do similar things in Quick Base.

I have a table that contains 3 fields:
 - Date
 - # of trucks here
 - # of trucks serviced

I'd like a report that summarizes everything by week, showing the total number of trucks that were here each week, the total number of trucks that were serviced each week, and then the percent of trucks that were serviced each week ([Total Number Serviced]/[Total Number Here])

I've figured out how to generate a 6-digit n​umber for each date (yyyyww) showing the year and weeknumber in that year.

Using that yyyyww number, I can create a report showing the number of trucks here and serviced for each of those weeks (those are totals generated by the report).

Where I'm stuck is figuring out how to come up with the percentage of trucks serviced each week.

Help!

------------------------------
Rob Reiterman
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

No problem

Quick Base you will need to summarize these data up to another table of weeks with the key field set up be that yyyyww value. 


I would use excel to import the next few years of weeks into a new table and set that field to be the key field. 

Then make a relationship where one week has many shipments. 


Then make summary fields on that relationship to summarize the number of trucks here and the number of trucks serviced. Then make your formula numeric field to calculate %



------------------------------
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+19
  • DonLarson
  • Qrew Cadet
  • February 9, 2020
Rob,

MS Access.  I remember having to hook Crystal Reports......

No matter what DB you are in, at some point you exceed the limits of its ability to natively do reporting.  Most DB's have no native capability and you have to use a reporting tool to get to anything.    If you are reporting needs are exceeding QB have you considered Tableau or PowerBI?   There is a PowerBI connector to Quick Base so you can get to some basic data pretty easy.   

If you want to curate to optimize you will need to do an extract which we can help you with.  Reach out if a SQL answer is appropriate.

------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
Terms & ConditionsAccessibility statement