Forum Discussion

TylerParker's avatar
TylerParker
Qrew Assistant Captain
7 years ago

A report to show the count of times that a resource in a related table was used in another table's records

Looking for some guidance

I have three tables, table A contains daily records of delivery routes, table B contains the vans used, table C contains the names of the drivers

I want a report from table A, grouped by name of the driver, to show me the count of the van that they use the most (aka the most frequent pairing of name X and van Y, and the # of times). The final desired result would look like:

Dave     Van 1     107
Eric       Van 8     88
Tim        Van 4     45
Roger    Van 5     134

Thanks to anyone taking a look at this
App builders
Ask about Quickbase functionality
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    np,
    Make a summary report type by driver by van.
    It will initially sort alpha.  But then click twice on the column for the counts and it will sort high to low, then SAVE.