I am looking to perform a query from a company table with a category table. I’m attempting to understand how to get a list of the number of companies per category. (this is a simple one to many relationship).
Any insight on how to do this would be greatly appreciated. I’ve spent tons of time looking into the docs and can’t make heads or tails out of it. (I have also looked into the Agile Reports, however, it seems like it is not up to date with the recent version of Agile, so I’m a bit stuck!)